SQL JOIN clause

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

Types of SQL JOIN:

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.

  Next Topic: SQL INNER JOIN with example. Previous Topic: SQL HAVING clause with example.