COURSE 3 OF 15
Joining Tables
Put rows from two tables side by side, keep the ones that should survive, and find the ones with no partner.
Builds on
Best read after 2. Grouping and Aggregation — you can still read ahead, but some of this may lean on ideas covered there.