Jump to content

is this possible with 1 query?


aebstract

Recommended Posts

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 :(

Link to comment
https://forums.phpfreaks.com/topic/187826-is-this-possible-with-1-query/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.