Visualize
SQL joins
Inner, left, right, full, cross, made visible. Change the inputs and step through it.
SQL joins: what it shows
A join combines rows from two tables. Pick inner, left, right, full or cross join and see which rows match, which are kept without a partner (with NULLs), and which are dropped.