Re: how quick query can be

"Julia Sats" <julia.sats_at_sympatico.ca> wrote in message news:<jt%Sa.1110$Wh.343036_at_news20.bellglobal.com>...
> update (select b.b2 from b where b.b1 = a.a1) set a2 = b2
>
> Ok, now correct.
> Can you propose something quicker now ?

I can not see any sense in what you wan't to do, can you be more specific ?

Do you just want to duplicate your table ?

Drop Table A
Create Table A as Select * from B

or do you have two tabels that should have the same data after every change ? Then use a trigger on table A wich also changes table B Received on Tue Jul 22 2003 - 17:24:38 CEST