Before you say VFP8 is "broken" be sure to read the "What's new" stuff. The SQL GROUP BY behavior was changed for VFP8. Try looking into SET ENGINEBEHAVIOR.

Mike

>Did any one use GROUP BY for SELECT - SQL? Why I alway get error message invalid GROUP BY? I think the VFP 8.0 is broken product I try convert my applications from VFP6.0 to VFP8.0 none of them work anymore.
>
>Thanks, Tai Fei Pao