Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Get unmatched values and matched values from two tables. RE: Get unmatched values and matched values from two tables.
John Mitchell-245523
SSC Guru
Points: 148809
More actions
April 10, 2015 at 8:35 am
#1790187
Yes, putting a column from the outer table into your WHERE clause turns your outer join into an inner join. Try turning WHERE into AND so that it becomes part of the join predicate.
John