SQL within RPG

I have a program that calculates sales for each of our customers based upon 
the type of sale it is (defined by a line type), it is using embedded sql 
and works fine.  What I would like to do is expand it so that I can display 
for each customer within the subfile their totals sales for two or possibly 
three seperate line types IE: line haul charges, stop off charges, fuel 
surcharges.

Is there a way to do this without having to create a work file or re-run the 
sql query for each line type? What I mean is this, is it possible to select 
the sums for each of sales for each line type grouped by customer?


If you bought it, it was hauled by a truck - somewhere, sometime.