Data, Decoded
A LEFT JOIN Can Lose Its Unmatched Rows When the Filter Moves
Use a two-customer example to see why filtering a right-hand table in WHERE can remove rows preserved by a LEFT JOIN.
Follow your curiosity
SQL joins
Use a two-customer example to see why filtering a right-hand table in WHERE can remove rows preserved by a LEFT JOIN.