o:
SELECT maintable.* FROM maintable, temptable WHERE maintable.id =
temptable.id;
tamsin
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Mitch Vincent
> Sent: 12 June 2001 15:25
> To: Zak McGregor; [EMAIL PROTECTED]
> Subject: Re: [GENE
D]
> Subject: [GENERAL] Large OR query
>
> Hi all
>
> If I have say 1000 values for an ID field, what is the best way to
> select from a table all the corresponding records?
> I have tried
> select * from blah where id in (id1,id2,id3...id1000)
> and
> select * from bl
Hi all
If I have say 1000 values for an ID field, what is the best way to
select from a table all the corresponding records?
I have tried
select * from blah where id in (id1,id2,id3...id1000)
and
select * from blah where id=id1 or id=id2 ... or id=id1000
and both are pretty slow.
Is there a bet
