# Joining Tables

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

Updated: November 16, 2026

1. [Joining Tables: an overview](https://www.ask-codey.com/lessons/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](https://www.ask-codey.com/lessons/joining-tables-inner-join) (Journeyman): How an INNER JOIN combines two tables and returns only the rows that have a match in both.
3. [OUTER JOIN](https://www.ask-codey.com/lessons/joining-tables-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.

Source: https://www.ask-codey.com/courses/java-full-stack-bootcamp/topics/joining-tables
