Unit 3: Joins: combining tables

Put rows from two or more tables side by side, keep or drop the rows that have no match on purpose, and spot the joins that quietly double your totals.

The big picture

Data is split across tables so each fact is stored once. Joins put it back together. Nearly every real query and most interview questions use at least one join — and most wrong answers come from choosing the wrong kind.

Lessons in this unit