Finding unmatched TSQL 1

[AshleyRickards]

I need to find records in one table where they don't exists in the primary table. I have deletes and changes based on SSN but not all records match in the update files to primary table so I need to extract those and make them adds.

TIA Ashley L Rickards
SQL DBA

 

[fluteplr]

select * from table1
where not exists
(select * from table2 where table1.key = table2.key)

replace tablle and key with the appropriate table and field names.

 

[AshleyRickards]

thanks .. that worked great. Ashley L Rickards
SQL DBA