>>>>>That was a tip by Tamar Granor on the last NY User Group meeting.
>>>>
>>>>Did you test it?
>>>
>>>Nope and even can not - since I don't have VFP9. But if I recall correctly we did run tests for this technique. The other question is to get original recno() back - that is also solved with derived tables but in the different order.
>>
>>It gives 'syntax error' in VFP9.
>
>
>Can you put your exact sample here please?

It was exactly your sample.