As Jim Nelson mentioned, using the NOFILTER clause in your SELECT statement may help. It eliminates the need to SELECT...INTO TABLE if you are doing further queries from the results. This usually is only a problem when you query a single table...usually.

I can't say that I remember having the problem you mention anyway.

Dana

>Hello all! I have a SQL Select statement storing the results to a temp table. When the Select statement runs and doesn't return any results, _TALLY is returning 1. Has anyone seen this before? Can anyone tell me why this is happening? If I store the contents to a cursor _TALLY returns the correct value, but I have to use a table because of other processing that follows.
>
>TIA!