>Hi Bruce,
>
>You didn't tell me the amount of data you're working on. Indexs are a good solution, since SQL Select uses it if existed.
These have 500,000 records or more. The problem though, is that NOT IN does not use indexes, only IN is optimizable. So my keyfield indexes are sitting idle, unable to help here :(
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.