merge into TABLE2 as trget
using ( 
select TABLE1_POLE1 from TABLE_1
       ) as source
  ON (source.TABLE1_POLE1 = target.TABLE2_POLE1)
 AND (source.TABLE1_POLE2 = target.TABLE2_POLE2)
===========================
далее какие нибудь условия, типа WHERE AND OR 
 для source, например
 AND (source.TABLE1_POLE3 is not null
===========================------------------------ далее
WHEN MATCHED
   AND (source.*****))
     THEN UPDATE
      set
WHEN NOT MATCHED
   and (soure.******)
     THEN INSERT (targget values)
      VALUES (source.values)
END 
GO

INSERT (targget values)
      VALUES (source.values)
END 

  ON (source.TABLE1_POLE1 = target.TABLE2_POLE1)
 AND (source.TABLE1_POLE2 = target.TABLE2_POLE2)
===========================
далее какие нибудь условия, типа WHERE AND OR 
 для source, например
 AND (source.TABLE1_POLE3 is not null

INSERT (targget values)
      VALUES (source.values)
END