Summary results in SQL

This is the select statement for a Showcase query that's pulling data from
the iSeries.  On a typical green-screen query you can select summary or
detail data from the "Select output type and output form" option.  Can that
be done with SQL?  Basically, we just want to see a part number, the total
quantity, and the total of the cost * quantity.  If it helps, forget
Showcase; how would you do this in green-screen SQL?


SELECT DISTINCT
      TPROD,
      TQTY,
      TQTY * TSCST AS COLUMN0000
FROM
      V40BPCSF.ITHL15 ITH
WHERE
      TWHS IN( '11', 'HT' )
      AND TTDTE BETWEEN &TTDTE1 AND &TTDTE1
      AND TQTY <> 0
      AND TTYPE IN( 'M', 'PR' )
      AND TPROD BETWEEN &TPROD2 AND &TPROD2
      AND TLOCT IN( 'INXT', 'RMDI', 'DWIP' )


Dave Parnin
--
Nishikawa Standard Company
Topeka, IN  46571
daparnin@xxxxxxxxxxxxxx