>From the "SELECT - SQL" help:
>
>Important Keep the following information in mind when creating join conditions:
>
>If you include two tables in a query and don’t specify a join condition, every record in the first table is joined with every record in the second table as long as the filter conditions are met. Such a query can produce lengthy results.
>
>Be careful when using, in join conditions, functions such as DELETED( ), EOF( ), FOUND( ), RECCOUNT( ), and RECNO( ), which support an optional alias or work area. Including an alias or work area in these functions might yield unexpected results. SELECT doesn’t use your work areas; it performs the equivalent of USE ... AGAIN. Single-table queries that use these functions without an optional alias or work area will return proper results. However, multiple-table queries that use these functions — even without an optional alias or work area — might return unexpected results.
>
>
>Fred,
>
>Thank you for taking the time to look that up. After you pointed it out, I found in VFP 50a help just as you indicated. Missed it the first time.
>
>Regards,

No problem. I used to spend a fair bit of time just scouring help files for what was new/different. This was back in the old FP 1.0/2.0 days where the printed documentation was hopelessly behind the actual product. I don't get to do it as much as I used to. I can now remember that I saw something, I just can't remember where! Thankfully, there are search engines etc, to help out.