Thanks Brian,
It works! Of course....
Bye!

----- Original Message -----
From: "Brian Dunstan" <bdunstan@...>
To: <IBObjects@egroups.com>
Sent: Sunday, December 03, 2000 11:05 PM
Subject: RE: [IBO] two or more SUM


> 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/
> > --------------------------------------------------------------
> > -------_->
> >
> >
> >
>
>
>
>
>