Enrico,

you can put in field aliases. EG:

SELECT SUM(COL1) SUM_COL1, SUM(COL2) SUM_COL2
FROM ........(and so on..)

That should work with any query object.

HTH,

Brian

> -----Original Message-----
> From: Enrico Cima [mailto:enricima@...]
> Sent: Monday, 4 December 2000 5:53 AM
> To: ibobjects@egroups.com
> Subject: [IBO] two or more SUM
>
>
> 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]
>
>
> -------------------------- eGroups Sponsor
> -------------------------~-~>
> eLerts
> It's Easy. It's Fun. Best of All, it's Free!
> http://click.egroups.com/1/9699/1/_/685810/_/975880593/
> --------------------------------------------------------------
> -------_->
>
>
>