Why does my LEFT JOIN behave like an INNER JOIN?
A WHERE condition on the right-hand table throws away exactly the rows the LEFT JOIN kept. Where each condition belongs, plus anti-joins, counting and fan-out traps.
In this article
- 01Why the rows vanish
- 02Fix: put right-table conditions in ON
