Re: Update on a join

From: Javier <jmoreno_at_hag.es>
Date: Mon, 19 Feb 2001 16:48:29 GMT
Message-ID: <x7ck6.17$bA6.1279@telenews.teleline.es>

Try this:

UPDATE Table1
SET Table1.FldX = (SELECT Table2.FldY FROM Table2 WHERE Table1.Key = Table2.Key);

This will do the job.

"Dave Sutton" <dpsutton_at_marchsystems.co.uk> escribió en el mensaje 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 - 10:48:29 CST