A JOIN is a keyword used to retrieve data from multiple tables based upon the relationship between the fields of the tables and present the results as a single set. The various types of JOINs commonly include INNER JOIN, OUTER JOIN, LEFT JOIN and RIGHT JOIN.