databasessql
Where should a right-table filter go in a left join?
Anonymous
on limits which right-side rows match; where filters the joined rows afterward. A condition on the right table in where can remove unmatched left rows. Keep it in on when those unmatched rows should remain.
0