SYMPTOMS You have a query with an OUTER JOIN (aka LEFT JOIN, RIGHT JOIN, LEFT OUTER JOIN, RIGHT OUTER JOIN), and you need to put filter criteria on the table or view that is outer joined. But when you do that, the query acts like an inner join. Consider the following query: It's designed to show...
Posted to
Number2 Blog - MyITForum.com
(Weblog)
by
jnelson
on
11-16-2007
Filed under: SQL, SMS, SMS 2003, sql 2005, v_GS_SoftwareFile, right outer join, inner join, right join, join, v_FullCollectionMembership, left outer join, outer join, V_R_System, left join