What are the Different types of joins and what is different between of each joins?

LEFT JOIN ,  RIGHT JOIN .FULL Outer JOIN

Different Joins are

1.Left Join

 Returns all rows form the left table, even if there are no matches in the right table.

2.Inner Join

  Inner join returns records at the intersection of the two tables.

3.Right Join

Right join is a mirror version of the left join and allows to get a list of all orders, appended with customer information

4. Full Join

list of all records from both tables

3.

SQL Join Types:

INNER JOIN: returns rows when there is a match in both tables.

LEFT JOIN: returns all rows from the left table, even if there are no matches in the right table.

RIGHT JOIN: returns all rows from the right table, even if there are no matches in the left table.

FULL JOIN: returns rows when there is a match in one of the tables.

SELF JOIN: is used to join a table to itself as if the table were two tables, temporarily renaming at least one table in the SQL statement.

CARTESIAN JOIN: returns the Cartesian product of the sets of records from the two or more joined tables.

there are three types of joints

1) Inner join

2)Left outer join

3)Right outer join