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?


Regards,


Ann