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".

Bob