SQL joins are used to combine rows from two or more tables based on a related column between them. The main types of SQL joins are: INNER JOIN LEFT JOIN (or LEFT OUTER JOIN) RIGHT JOIN (or RIGHT OUTER JOIN) FULL JOIN (or FULL OUTER JOIN) CROSS JOIN SELF JOIN (This is not a unique command but a standard join used to join a table to itself)