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
I would load the 1000 values into a temporary table, and join on the ID
field. I usually find that approach gives much faster results.
> -Original Message-
> From: Zak McGregor [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, June 12, 2001 7:42 AM
> To: [EMAIL PROTECTED]
> Subject: [GENE