Ben Nadel at RIA Unleashed (Nov. 2010) with:
( photo link )
Posted on Aug 25, 2010 at 10:48 AM
I personally put any filters on the joined tables in the ON instead of the WHERE, that way I can change from INNER to OUTER joins without needing to adjust the rest of the code.... read more »
Ben Nadel © 2013.
All content is the property of Ben Nadel and BenNadel.com