Part 1 of 5 · 1 min read
Why this page comes first
In this module you will
- Write an inner join and explain which rows it drops.
- Write a left join and explain what it keeps that an inner join would drop.
- Explain the difference between a right join and a full join.
- Know when a cross join is the correct tool, and when it signals a missing join condition.
The previous two pages showed joins in formal notation. This page covers every join type SQL actually offers, including the behavior that trips people up most: what happens to a row with no match on the other side.