Outer join with condition

  • Very Nice QtoD. (the joins are finally getting stronger... 🙂 )

    ww; Raghu
    --
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

  • Good question, thanks. 🙂

  • 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. 😀

Viewing 3 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply