Re: how quick query can be
From: <sybrandb_at_yahoo.com>
Date: 21 Jul 2003 00:52:39 -0700
Message-ID: <a1d154f4.0307202352.6fd713ec_at_posting.google.com>
Date: 21 Jul 2003 00:52:39 -0700
Message-ID: <a1d154f4.0307202352.6fd713ec_at_posting.google.com>
"Julia Sats" <julia.sats_at_sympatico.ca> wrote in message news:<ijHSa.769$1I5.141057_at_news20.bellglobal.com>...
> I have two tables A(a1 number, a2 number) and B(b1 number, b2 number)
> a.a1 and b.b1 are join columns .
> I need to update values of a2 by values of b2.
>
> we can use such update quere
> update A set a2 = (select b.b2 from b where b.b1 = a.a1)
>
> Can you propose something quicker ?
>
> Thanks
Switch to a different database. Your query is incorrect too.
Sybrand Bakker
Senior Oracle DBA
Received on Mon Jul 21 2003 - 09:52:39 CEST