select * FROM A Where id in ( Select id from A EXCEPT Select id from B )
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)