Re: Update on a join

update table1 table_alias
set fldx = (select fldY from table2 where key = table_alias.key)

"Dave Sutton" <dpsutton_at_marchsystems.co.uk> wrote in message news:96rhnl$h16$1_at_newsreaderm1.core.theplanet.net...
> 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 - 11:05:41 CST