Update on a join

Help!!

I need to perform an update on a single table but the information to be used in the update comes from another table.

In SQL server I would have used:

UPDATE Table1
Set Table1.FldX = Table2.FldY
FROM Table1, Table2
WHERE Table1.Key = Table2.Key

But ORACLE won't allow me to do this.

Any ideas??

Thanks.

Dave Received on Mon Feb 19 2001 - 10:31:27 CST