Hi All:
How do can I use Group by in VFP 8? I am using the following command and it gives me an error, what am I doing wrong.

SELECT * from mytable2 GROUP BY ID INTO CURSOR ctemp.
The error is sql: Group by clause is missing or invalid.
Thanks
MA