Tag: What are the types of join and explain each?

There are various types of join that can be used to retrieve data and it depends on the relationship between tables.

Inner Join

Inner join return rows when there is at least one match of rows between the tables.

Right Join

Right join return rows which are common between the tables and all rows of Right-hand side table. Simply, it returns all the rows from the right-hand side table even though there are no matches in the left-hand side table.

Left Join

Left join return rows which are common between the tables and all rows of Left-hand side table. Simply, it returns all the rows from Left-hand side table even though there are no matches in the Right-hand side table.

Full Join 

Full join return rows when there are matching rows in any one of the tables. This means it returns all the rows from the left-hand side table and all the rows from the right-hand side table.