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...).
[ Parent
| on HN ]
There are no comments on this comment yet.