MySQL Joins

Joins in MySQL facilitates the retrieval of information from multiple tables.
In MySQL We have following Types of Joins. Basically, in a single result set we can get the columns of multiple tables by means of Joins.

  1. INNER JOIN
  2. OUTER JOIN
    • LEFT OUTER JOIN
    • RIGHT OUTER JOIN
    • *FULL OUTER JOIN
  3. CROSS JOIN
  4. SELF JOIN
  5. EQUI JOIN
  6. NATURAL JOIN
  7. STRAIGHT JOIN
  8. JOIN WITH USING

The subsequent MySQL Tutorial articles explains each of these JOINS by visual JOIN representation and with extensive list of examples.

*FULL OUTER JOIN: MySQL doesn’t support FULL OUTER JOIN, but we can achieve the FULL OUTER JOIN result by combing the LEFT OUTER JOIN and RIGHT OUTER JOIN results by UNION clause.

Leave a Reply

Your email address will not be published. Required fields are marked *