Missing or incorrect ON clause produces m x n rows 2. **Wrong outer join direction** — Preserving the wrong table (check which side is LEFT vs. RIGHT) 3. **WHERE clause on outer table** — Nullifies the outer join, silently converting it to inner 4. **Row multiplication in aggregates** — Joining one-