Introduction to MySQL Joins

What is Join?

An SQL JOIN clause combines records from two tables in a relational database, resulting in a new, temporary table, sometimes called a "joined table". A JOIN may also be thought of as a SQL operation that relates tables by means of values common between them. SQL specifies four types of JOIN: INNER, OUTER, LEFT, and RIGHT.

Types of Joins?

1. LEFT OUTER JOIN (or simply LEFT JOIN)
2. RIGHT OUTER JOIN (or simply RIGHT JOIN)
3. INNER JOIN or (EQUI JOIN)
4. CROSS JOIN
5. FULL OUTER JOIN
6. NATURAL JOIN
7. SELF JOIN


Reference Sites :

1. Wikipedia.org