Update SQL differences

In Sybase, the following command will succeed.

update tablename
set t.columname = t1.columname
from tablename t, othertable t1
where t.id = t1.id

In Oracle it fails with a syntax error. I know that I can write a correlated subquery and get the same results, but I wonder if there is a different way. If the correlated subquery is the only way in Oracle, is the subquery flattened into a join by the optimizer?

Thanks,

Carlos Pereyra

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri May 07 1999 - 12:15:07 CDT