News for hackers. Stuff that matters.
Re:Things I wished more developers knew about databases by saltcured on Wednesday April 22, 2020 @01:09PM (#22947792)
The extra "AND expr" in the join clause makes it more strict, which means the outer join can produce more nulls in the joined tuple. In a sequence like A left join B left join C, moving the extra join filter between the two joins is the difference between getting tuples like (a..., null..., null...) vs (a..., b..., null...).

There are no comments on this comment yet.