Joining Tables

Joining Tables: Joining Tables: an overview, INNER JOIN, OUTER JOIN.

Updated

  1. Joining Tables: an overview (Apprentice): The two kinds of join, inner and outer, and the small chores database (person and task) used to compare them.
  2. INNER JOIN (Journeyman): How an INNER JOIN combines two tables and returns only the rows that have a match in both.
  3. OUTER JOIN (Journeyman): How LEFT, RIGHT and FULL outer joins keep unmatched rows from one or both tables, and how to get a full join in MySQL, which has no FULL OUTER JOIN.