Re: Update on a join

From: Dave Sutton <dpsutton_at_marchsystems.co.uk>
Date: Wed, 21 Feb 2001 12:05:50 -0000
Message-ID: <970asu$eg1$1@newsreaderg1.core.theplanet.net>

Thanks for your help guys.

Dave

"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 Wed Feb 21 2001 - 06:05:50 CST