GilaMonster (2/18/2010)
river1 (2/18/2010)
Make a "inner join on x=Y" or make "select ..... where x not in (select y)"Unless I'm missing something, those will not return the same result.
I was thinking the same thing. The 'inner join' and 'not in' logic are antonyms in this case.
Karl Lambert
SQL Server Database Administration
Business Intelligence Development