• Right, no minus. I would recommend using JOIN like this:

     

    SELECT *

    FROM Table1 a

    LEFT JOIN Table2 b

      ON a.Col1 = b.Col1 AND a.Col2 = b.Col2

    WHERE b.Col1 IS NULL

    I think previous example would cause SQL server to run multiple queries against data, while this one simply joins tables and extracts rows that exist in table B.