Re: sum in SQL?

On Tue, 10 Dec 2002, Peter Dow wrote:

>     SELECT CUSTNBR, CUSTNAME, SUM(INVTOT), CUSTYTD
>       FROM CUSTOMERFILE JOIN INVOICEFILE ON CUSTNBR = INVCUSTNBR
>      WHERE INVMONTH = 12
>      GROUP BY CUSTNBR, CUSTNAME, CUSTYTD
>
> I'm assuming that CUSTYTD is a field in your CUSTOMERFILE.

Excellent!  Good assumption, the YTD totals are in the customer file.
Here is what I used:

select cmcst#6, cmcst#3, cmcsname, sum(ihinvtot), cmytdsal
from custmp, invchp where
cmcst#6=ihcst#6 and cmcst#3=ihcst#3 and ihinvdate>'2002-11-30'
group by cmcst#6, cmcst#3, cmcsname, cmytdsal

Now I wonder how I can pass a date to this from say a CL program?  And
make it print instead of display?  I want to put this on a menu that
prints out the results for the current month.

James Rich