• Using the Except operator, the following query returns any distinct values from TableA that are not also found in TableB.

    SELECT * FROM TableA EXCEPT SELECT * FROM TableB

    You may also use union all to find differences from the one and the other side .... as follows:

    SELECT * FROM TableA EXCEPT SELECT * FROM TableB

    unoin all

    SELECT * FROM TableB EXCEPT SELECT * FROM TableA