On Tue, 12 Jun 2001, Mitch Vincent wrote:
> Is populating another table with the 1000 values and doing a
> SELECT * FROM <whatever> WHERE <something> IN (SELECT <something> FROM
> <whatever>) ?
>
> I'm not entirely sure that it will yield a better result but it's worth a
> try.
>
SELECT * FROM <whatever>,<temptable> WHERE whatever.id=temp.id;
is probably what you are after.
- Einar Karttunen
