>You know, I just remembered that I read something about using DELETED() in a query. Something about VFP's internal use of the deleted flag. I seem to remember that having a DELETED() tag is helpful, but do not use DELETED() in the query. Is this correct?
>

In fact, you shouldn't use any function that takes an alias as a parameter in a query that involves more than one table. That's why you're getting wrong results.

Tamar