INSERT INTO target1_table OUTPUT INSERTED.field1, INSERTED.field2 INTO target2_table (field1, field2) SELECT A.field1 ,A.field2 ,B.field3 ,B.field4 FROM source1_table A LEFT OUTER JOIN source2_table B ON B.field1 = A.field1 AND B.field2 = A.field2 WHERE A.field1 > B.field1