Subject Re: [firebird-support] Stupid Programmer or a bug?
Author Ann W. Harrison
Dalton Calford wrote:
> So I use IB_SQL to create a simple query
> select zone, description, count(description) as calls, sum(duration)
> from report group by calls order by description

That should have returned an error because you're returning
simple fields - not aggregates - that aren't in the grouping list.

I'm not sure what you're trying to do, but I doubt very much
that you can group by an aggregate that depends on the grouping.

What are you trying to do?