The JOIN is 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.