Jam Teense said..
Joins are used in SQL queries to explain how different tables are related. Joins also let you select data from a table depending upon data from another table.
Types of joins: INNER JOIN, OUTER JOIN, CROSS JOIN. OUTER JOIN are further classified as LEFT OUTER JOINS, RIGHT OUTER JOINS and FULL OUTER JOINS.