Ricky,
It's documented in VFP8 help under
Behavior Changes Since Visual FoxPro 7.0 and
INFO: SQL SELECT Behavior Changes in Visual FoxPro 8.0 mskb #
813361.
>All,
>
>I am using Visual Foxpro 8.0.
>When I use SQL command "Select * from table1 group by table1.field1 order by table1.field1". I always get error message "SQL: Group by clause is missing or invalid". But It is OK when I run it in VFP7.0.
>
>
>Regards
>Ricky
--sb--