EXCEPT
Use EXCEPT to return the results of the first query that are not included in the results of the second query. Each selection must have the same data types.
Syntax
Select * from object1 EXCEPT
Select * from object2
Use EXCEPT to return the results of the first query that are not included in the results of the second query. Each selection must have the same data types.
Select * from object1 EXCEPT
Select * from object2