From: "Paul" <paulhope@...>

> I've often wondered why we need it at all when it contains all the non
> aggregate fields in the select?
>

I agree, if the query is one table and all aggregates are fields of that
table. The problem would come in when you use other factors for the
aggregate fields and/or multiple tables. The engine wouldn't know that you
wanted it grouped by the non-aggregate fields, would it?

But that makes it a development conversation and not a support one so I
better stop before ^Helen shows up. :-)

Woody (TMW)