I thought that VFP9 did not allow ordinal in the GROUP BY clause.

Anyway, when it comes to SQL's like this, I prefer to split it up into 2 or more views and then combine the views into the one cursor I need. This way I can more readily tweak performance and understand what is going on.