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