Update on join, how?
From: L. Tseng <lesliet_at_u.washington.edu>
Date: 1996/11/07
Message-ID: <55t5eg$54f_at_nntp1.u.washington.edu>#1/1
Date: 1996/11/07
Message-ID: <55t5eg$54f_at_nntp1.u.washington.edu>#1/1
[Quoted] [Quoted] 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 CET