Flashcards
Join types with diagrams, fan-out and NULL traps, anti-joins, correlated subqueries, recursive CTEs and set operators, with worked examples on small tables.
Which join does this Venn diagram show, and what rows does it return?
Tap to flip
INNER JOIN: only rows that have a match in both tables (the overlap). Unmatched rows from either side are dropped.
Tap to see the front