MERGE INTO table1 t1
USING
(
-- For more complicated queries you can use WITH clause here
SELECT * FROM table2
)t2
ON(t1.CONTRACT_ID = t2.AGREEM_ID)
WHEN MATCHED THEN UPDATE SET
t1.MATERIAL_IDENTIFY = t2.MATERIAL_IDENTIFY;
MERGE INTO table1 t1
USING
(
-- For more complicated queries you can use WITH clause here
SELECT * FROM table2
)t2
ON(t1.SM_ID = t2.CONTRACT_ID)
WHEN MATCHED THEN UPDATE SET
t1.SPLIT_MARKER = t2.SPLIT_MARKER;
