Re: Update on join, how?

L. Tseng wrote:
>
> Does anyone know how to do an update on join like in Sybase/MS SQL Server?
>
> update table_A
> set a.cola = 'x'
> FROM table_A a, table_B b
> where a.col = b.col
> and .......
>
> It seems to me Oracle does not support the 'FROM' in an update syntax?
> If yes, why is that? Thanks.

Use the correlated subselect capability:

	update table_A a set a.cola = (
	    select cola from table_B b
	    where a.col = b.col
	      and .....);

brucer Received on Thu Nov 07 1996 - 00:00:00 CET