>Hi anyone,
>I realize that VFP8 is now more 'purest' with SQL expressions. But what would be wrong with the following that would render error "SQL: GROUP BY clause is missing or invalid." (For what it's worth, this code sample was created by Query Designer.) See the topic "Behavior Changes Since Visual FoxPro 7.0" in the Help -> What's new in VFP8..
See also:
--- INFO: SQL SELECT Behavior Changes in Visual FoxPro 8.0 ---
http://support.microsoft.com/?id=813361 SET ENGINEBEHAVIOR 70/80