Updating 2 tables

[tamilselvan]

Halo, it won't work.

The workable statement is:

UPDATE TABLE1 A SET (A.COL2, A.COL3) =
(SELECT B.COL2, B.COL3 FROM TABLE2 B WHERE A.KEY1=B.KEY2);