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