>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

Mahmood,

Beginning in Version 8, group by clauses have to include all non aggregated fields.

As an alternative, you can SET ENGINEBEHAVIOUR 70.

HTH,