Re: Help on Update Query

The syntax is wrong.
Try this:
update Table1 T1

    set (col1, col2, col3) =

        (select col1, col2, col3 from Table2 where col1 = T1.col1);

Regards,

    Dmitriy Agafonov

Shankar Muthukrishnan wrote:

> I am able to execute the following query on Microsoft SQLServer.
> The update plugs in 3 column values from T2 into T1.
> update T1
> set T1.col1 = T2.col1,
> T1.col2 = T2.col2,
> T1.col3 = T2.col3
> from Table1 T1, Table T2
> where (T1.key = T2.key)
>
> Any help on Oracle is appreciated.
> Thanks.
Received on Sun Jan 04 1998 - 00:00:00 CST