SELECT * FROM tableA
EXCEPT
SELECT * FROM tableB
--EXCEPT returns any distinct values from the left query that are not also found on the right query.
SELECT * FROM tableA
INTERSECT
SELECT * FROM tableB
--INTERSECT returns any distinct values that are returned by both the query on the left and right sides of the INTERSECT operand.