CSE Roadmap

Core tier · about 3 hours · 5 parts

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.