SQL Server — LEFT JOIN + WHERE Turns Into INNER JOIN

SQL

This is a classic silent bug:

LEFT JOIN Orders o ON o.UserId = u.Id
WHERE o.Status = 'Paid'

Rows without orders are removed.

Move condition into JOIN.

SQL — BETWEEN Can Return Unexpected Rows

Post Views: 5