>>
>>BTW if your order by is same as group by then you don't need order by (group by does implicit order by).
>>Cetin
>
>I wouldn't recoment it for a few reasons:
>- It's could be changed in the future versions of VFP
>- It's not obvious nor documented
You might be right. VFP7 made some changes to SQL engine. For the moment it does so and according to MS we should test each and every SQL for their correctness in VFP7 while upgrading.
Cetin