update DB2 table with values from another table


Situation Text to be written later.

UPDATE TABLE01 T1
SET (T1.FIELD01, T1.FIELD02)
=
(SELECT CROSS_FIELD_01, CROSS_FIELD02
FROM TABLE02 T2
WHERE T2.MATCHING_FIELD = T1.MATCHING_FIELD
)

End of code text

Leave a comment

Filed under Sharing Stuff

Comments are closed.