>>Dmitry
>>
>>Are you using a JOIN in the SQL or just WHERE. Using a join can speed the SQL up manifold.
>>
>
>Terry,
>
>In this particular case, where I am trying to reduce the number of selected records, there is no JOIN, only WHERE. I don't know how I can add JOIN to this SQL Select since the records are pulled from one table.
>
>Thank you.
OIC - you're just "filtering" the data from one table only. Well AFAI can see you've only the "TOP n" option then :-)
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.
