On Wednesday 28 May 2003 18:21, Dave Tenny wrote:
> Having grepped the web, it's clear that this isn't the first or last
> time this issue will be raised.
>
> My application relies heavily on IN lists. The lists are primarily
> constant integers, so queries look like:
>
> SELECT val FROM table WHERE id IN (43, 49, 1001, 100002, ...)
How do you derive this list of number? If it is from same database, can you
rewrite the query using a join statement?
HTH
Shridhar