SELECT TableA.Id FROM TableA WHERE TableA.Id NOT IN ( SELECT TableB.Id FROM TableB )
except
select * from TableA except select * from TableB
SELECT * FROM TableB T2 WHERE NOT EXISTS (SELECT * FROM TableA T1 WHERE T1.ID = T2.ID)
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)