INNER JOIN: Returns rows with matching values in both tables.

LEFT JOIN: Returns all rows from the left table and matching rows from the right table.

RIGHT JOIN: Returns all rows from the right table and matching rows from the left table.

FULL JOIN: Returns all rows with matches in either table.

CROSS JOIN: Returns the Cartesian product of both tables, producing all possible combinations.

There are four main types of JOINs in SQL: INNER JOIN, OUTER JOIN, CROSS JOIN, and SELF JOIN.

SQL has four primary JOIN types: SELF JOIN, CROSS JOIN, OUTER JOIN, and INNER JOIN. But keep in mind that there are two variations of outer joints: right and left. A FULL OUTER JOIN is also separated by certain specialists.