how quick query can be
From: Julia Sats <julia.sats_at_sympatico.ca>
Date: Sun, 20 Jul 2003 21:21:28 -0400
Message-ID: <ijHSa.769$1I5.141057_at_news20.bellglobal.com>
Date: Sun, 20 Jul 2003 21:21:28 -0400
Message-ID: <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 .
we can use such update quere
Can you propose something quicker ?
I need to update values of a2 by values of b2.
update A set a2 = (select b.b2 from b where b.b1 = a.a1)
Thanks Received on Mon Jul 21 2003 - 03:21:28 CEST