Re: how quick query can be
From: Mike <y1799_at_yahoo.com>
Date: 24 Jul 2003 12:54:02 -0700
Message-ID: <93f42f92.0307241154.1959340a_at_posting.google.com>
> "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
Date: 24 Jul 2003 12:54:02 -0700
Message-ID: <93f42f92.0307241154.1959340a_at_posting.google.com>
mountainsports_at_gmx.de (Yak) wrote in message news:<d2880e11.0307220724.3986515a_at_posting.google.com>...
> "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
Tables A and B do not contain only by 2 fields each. At this case drop table A and create it again as select from B do not work. At this case has to be updated only one column without change other data. BTW select count(*) from A and select count(*) from B can be different. Received on Thu Jul 24 2003 - 21:54:02 CEST