Good question and nice discussion. I too prefer the left join syntax using the where clause for filtering in a subquery. It's just easier to read in my opinion. I don't see a lot of right joins in use but I do see filtering applied to ON statements now and again. I usually end up re-writing those queries as I catch them. 😀