UPDATE
TEST_TABLE1 T1
SET
(T1.AA, T1.BB, T1.CC) =
(
SELECT
DD, EE, FF
FROM
TEST_TABLE2 T2
WHERE
t1.id=t2.id)
UPDATE
TEST_TABLE1 T1
SET
(T1.AA, T1.BB, T1.CC) =
(
SELECT
DD, EE, FF
FROM
TEST_TABLE2 T2
WHERE
t1.id=t2.id)