>In the old days (VFP 7) I did the occasional GROUP BY and things went well. It was ... well it seemed intuitive.
>
>With VFP 9, the rules have changed, and no matter how many time I read what I can find in the help files, everything seems inside out now. I seem to end up with a GROUP BY clause that needs about 15 fields listed (none of which I want to group by).
>
>Can someone point me to an article of some sort that will fix this mental block that I have on the philosophy of GROUP BY? I'm getting really tired of "SQL: GROUP BY clause is missing or invalid".

Hi Bob,

Check Re: Change in SQL commands! Message #941774