While there are other types of JOINs supported by various flavors of SQL, most implementations of SQL support the INNER JOIN, LEFT JOIN, and RIGHT JOIN constructs.