Sergey, too quick on the draw. Unless I'm missing something, his select only selects 1 field from the table. He shouldn't be getting the error.

Alan

>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