Grouping Problem

[hays]

This is a newbie question but...

I have 3 essential pieces of data:
the service type (STYP),
the service category (SCAT),
and the consumption (BILLED_CONSUMP).

I'm trying to derive a query where I have STYP, SCAT, and then the sum of BILLED_CONSUMP grouped by STYP then SCAT. I haven't had any luck yet. Any suggestions would be appreciated.

 

[tlbroadbent]

You almost wrote the query in your post. Try this one.

Select STYP, SCAT, SUM(BILLED_CONSUMP) As Tot_Consump
From tbl
Group By STYP, SCAT Terry

http://members.home.net/tlbroadbent/sqlarticles.htm

"The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge." - Daniel J Boorstin