DB2 Update multiple columns and rows with Values from ...

UPDATE first_table t1. set (t1.column3, t1.column4, t1.column5, ...) = (. SELECT t2.column3, t2.column4, t2.column5, ... from second_table t2.

www.mysamplecode.com