Help on Oracle Update statement

Hi,

I am moving from Sybase to Oracle and I used to be able to do update statement like this in Sybase:

UPDATE 	TABLE1
SET		T1.field1 = T2.field2
FROM		TABLE1 T1, TABLE2 T2
WHERE	T1.field2 = T2.field2
AND		....

but in Oracle it is not valid. Does anyone know how to convert it to Oracle?

Thanks in advance.. Received on Thu Apr 29 2004 - 13:47:28 CDT