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 or is there something different with the
group by clause in VFP 8.0 ?

Thanks for your help
Stephen J. Hunt