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.