Hi everybody,

I wanted to find a thread about finding records in one table and not in another (if memory serves originated by Rich Pupko), but could not find it, so I'll post here

http://wiki.lessthandot.com/index.php/Subquery_typo_with_using_in

Hope this helps.

BTW, see this for 5 ways to find records not in another table

http://blogs.lessthandot.com/index.php/DataMgmt/DataDesign/the-ten-most-asked-sql-server-questions--1#4