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
--sb--