Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Update on join, how?
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. Received on Thu Nov 07 1996 - 00:00:00 CST