>>Yes, this Select should be splitted on two, the first one will do Select Distinct ... Into Cursor..., and next one will join the cursor.
>
>Not necessaraly. You can do the same if you move JOIN into where condition like
>

>where ResNum in (select distinct ResNum from ...)

BTW, looks like Rich's version was using the exact same syntax and it should work in prior to VFP9 versions.