I think if the original question was concerning a query from one table, then Hilmar was correct. If you SELECT from one table, then try to query the results set, you will get the message "Must use SELECT...INTO TABLE". If you are joining two tables this doesn't happen. VFP does, behind the scenes, a USE...AGAIN on the one table scenario. That's why the error. But with a join of two or more tables, that doesn't happen.
However, I, too, have gotten into the habit of always using NOFILTER. :)
Dana
>Hello Hilmar,
>
>I'm sure you are aware that this is not always true...I run ad-hoc queries and forget to use NOFILTER all the time, and I usually have no problems running queries against the results.
>
>But for production code, NOFILTER is certainly the safer route.
>
>> NOFILTER is required if the result of a query is used for further queries.
>>
Where's the damned Any Key?...too late