A = {1, 2, 3} B = {1, 2} A - B = {3}
select a.* from a left outer join b on a.Id = b.Id where b.Id is null
MSDN - EXCEPT and INTERSECT