RE: Using SQL to get a one total row from multiple rows

Dan,

Nope, not as far as I know.

I'm curious as to what you don't like about it.

Charles

> -----Original Message-----
> From: Dan Bale [mailto:dbale@xxxxxxxxxxxxx]
> Sent: Friday, August 06, 2004 6:18 PM
> To: midrange-l@xxxxxxxxxxxx
> Subject: Using SQL to get a one total row from multiple rows
> 
> 
> This is what I've got right now:
> 
> Select   Count(*), sum(InvAm), sum(SpCg2), sum(SpCg1),
>                    sum(TxTot), sum(CnsAm), sum(DAInT)
>  FROM      MTHACTX
>  WHERE     COMNO = 01 and TDate between 1040701 and 1040731
> 
> I am getting the expected & desired results: a one-row total 
> line.  Somehow,
> this doesn't strike me as the preferred way to do this.  I 
> scanned through
> the SQL Reference & Programming Concepts, and nothing is clicking.
> 
> Is there a better / more preferred way to do this?
> 
> tia,
> db
>