--- In ib-support@yahoogroups.com, "dixonepperson" <edepperson@j...>
wrote:

> do you mean my group by statement should read
> GROUP BY p.PO_NUM, c.CO_NAME, a.ADR_ADR1 ... n.DZIP
> because they are all non aggregate?

Yes. Server counts aggregates on distinct sets of returned general
columns and don't analyse underlying tables structure. It's how it
work by designs and it is semantic of the query - group aggregate by
distinct on returned values.

Best regards, Alexander.