>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
Bob,
It is actually quite simple - all the fields which are not part of the GROUP BY clause have to be wrapped in some aggregate function such as MIN, MAX, AVG, for example.
See
Re: This Select Group claims to be Missing or Invalid Thread #
1252346 Message #
1252417
If it's not broken, fix it until it is.
My Blog