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