>I have a select statement
>SELECT * FROM {table1} ORDER BY {field1},{field2} GROUP BY {field1},{field2}
>
>when I run this select statement in VFP 8.0 I get error
>"SQL: GROUP BY clause is missing or invalid"
>
>when I run it in VFP 6.0 or 7.0 it works
>Is this a known bug
No
>or is there something different with the
>group by clause in VFP 8.0 ?
Yes. See VFP8 Help and mskb #
813361 : SQL SELECT Behavior Changes in Visual FoxPro 8.0
--sb--