SQL JOIN clause

The JOIN are used to combine the records from two or more tables.

Types of SQL JOIN:

1. 1. SQL INNER JOIN.
2. SQL LEFT OUTER JOIN.
3. SQL RIGHT OUTER JOIN.
4. SQL FULL OUTER JOIN.
5. SQL SELF JOIN.
6. SQL CARTESIAN JOIN or CROSS JOIN.