• I may be making it too simple and missing some nuance of what you are after, but I think you just want a LEFT JOIN.

    SELECT t1.Field1,

    t1.Field2

    FROM @test1 t1

    LEFT JOIN @Test2 t2 ON t1.Field1 = t2.Field1

    AND t1.Field2 = t2.Field2

    WHERE t2.Field1 IS NULL;

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato