SQL JOINs

The JOIN clauses, when used with SELECT statements, combine rows from two or more tables, based on a related column between them and return a single table. However, no changes are made to the actual tables, and combined table is only created temporary in response to the query. SQL has several different types of joins, but the three most common for MySQL is INNER JOIN, LEFT JOIN, and RIGHT JOIN.