SELECT t1.Field1, t1.Field2FROM @Test1 t1 LEFT JOIN @Test2 t2 ON t1.Field1 = t2.Field1 AND t1.Field2 = t2.Field2WHERE t2.Field1 IS NULL;
DECLARE @Test1 TABLE (Field1 varchar(1), Field2 int);INSERT INTO @Test1SELECT 'A',1 UNION SELECT 'B',2 UNIONSELECT 'C',3 ;DECLARE @Test2 TABLE (Field1 varchar(1), Field2 int);INSERT INTO @Test2SELECT 'B',2 UNIONSELECT 'C',3 ;select * from @Test1 t1where not exists(select 1 from @Test2 t2 where t1.Field1 = t2.Field1 and t1.Field2 = t2.Field2);
SELECT * FROM @Test1 t2 WHERE NOT EXISTS (SELECT 1 FROM @Test2 t2 WHERE t1.Field1 = t2.Field1 AND t1.Field2 = t2.Field2)
We walk in the dark places no others will enterWe stand on the bridge and no one may pass