>>
>>select * from TableA where PK not in (select FK from TableB)
>>
>>See interesting discussion at
>>
http://blog.sqlauthority.com/2008/04/22/sql-server-better-performance-left-join-or-not-in/>
>Noami,
>
>You forgot the third possiblity
>
>SELECT * FROM TableA T1 WHERE NOT EXISTS(SELECT 1 FROM TableB WHERE FK = T1.PK)
>
>The EXISTS() clause is a very important and often underestimated insturment in resolving these types of queries. Above all it is a more natural translation of the asked question: Give me everything from table A which does not have records in table B.
>
>
>
>
>Walter,
Hi Walter,
I know about it, but it was discussed in the referenced blog in the comments.
If it's not broken, fix it until it is.
My Blog