Even though I still use my left and inner joins...

I think EXCEPT & Intersect are very nice. It's so much easier to explain data to some one who is not so much knowledgeable about joins which can be very initimidating at first.

Just my 0.2c!