Oracle Update SQL Help

Hi All,

Here's the scenario.

2 Tables Exactly the same data structure and data except for 3 fields in table A are null.

1 primary key in both tables. The data is all the same in Table A & B except for 3 fields in Table A.

Data Structure for both TBL A & B (example 1 row of data given below)

                            TBL A        TBL B
PK -     ID            1                1
            Col1         JKL            JKL
            Col2        NULL          ABC
            Col3        NULL          ABC
            Col4        NULL           ABC
            Col5        ABC            ABC

The data is the same just need to get the 3 fields in Table B into TAble A.

This is what I got but didn't work.

Update Table B
set TableB.col1 = TableA.col1,
TableB.col2 = TableA.col2,
TableB.col3 = TableA.col3
from table A
where TableA.id = TableB.id

--
Thanks,

Lanky