Performing a JOIN in an Update Statement (HELP)

Hello All:

I am trying to perform an INNER JOIN in an update statement in Oracle 8. I can't seem to get the format just right.

Can anyone help?

Here are the formats I've tried but failed at getting to work:

Example 1:
update Table1
set colB = table2.colB,

    colC = table2.colC
From Table2
Where Table1.ColA = Table2.ColA

Example 2:
update Table1
set colB = table2.colB,

    colC = table2.colC
Where Table1.ColA IN (SELECT Table2.ColA From Table2)

No good. Can anyone help?
As you can see, I'm updating table1 with some records from table2. Received on Wed May 22 2002 - 16:29:38 CEST