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.


>Hello,
>
>This look serious.
>
>I have SELECT aTABLE FROM MYTABLE GROUP BY 1
>
>and I get Group by clause is missing or invalid.
>
>Any help will be appreciated.
>
>VFP8 on XPsp1
>
>Thanks,
>Pablo