Subject Re: [IBO] two or more SUM
Author xomp@cadvision.com
Force the issue as desired

> SELECT SUM(COL1) AS SUM_1, SUM(COL2) AS SUM_2
> FROM ........(and so on..)

Enrico Cima wrote:
>
> Dear All,
> I've a little simple question for all of You who intend to give me a suggestion:
>
> I have this kind of Query
>
> SELECT SUM(COL1), SUM(COL2)
> FROM ........(and so on..)
>
> The result from IB_QUERY is two field with the same name
> SUM
>
> If i use other program as for example QUICKDESK for trying my query i have two field: SUM and SUM1.
> (Also with IBOQuery i have the same result SUM and SUM_1)
>
> What can i do for having the same with IB_QUERY?
>
> Thanks for Your reply.
> Best Regards,
> Enrico
>
> [Non-text portions of this message have been removed]
>