is this possible with 1 query?

[aebstract]

I don't think it will be, but what I got so far is a query to grab a few pieces of information:

 

SELECT so.dateissued, so.num, soitem.taxableflag, soitem.totalprice, so.shiptoname

FROM so
JOIN soitem ON so.id = soitem.soid

WHERE so.taxrate > '0'
AND so.dateissued >= '12-1-09'
AND so.dateissued <= '12-31-09'
AND billtozip = '95334'

ORDER BY so.shiptoname, so.dateissued

 

What I'm needing to do on the results, is have a total for each unique shiptoname and have it show in the results under each shiptoname's section. For this report there happens to be 3 unique shiptonames and like 50 results. Thing is I can only run 1 query and I don't think I can control the outcome enough to do it

[aebstract]

I think the answer is going to be more of whatever handles the query after it is ran is what needs to do it. I don't think it's going to be possible in the software I'm using, wish this was php ;(

[fenway]

Why can't you simply run through the result set and count yourself?