I'm trying to come up with a query that will tell me: 1) How many orders have been place 2) What the total income from those orders ad up to.
I tried this, but it isn't giving me what I expect: SELECT COUNT(STATUS) AS TotalOrders, PRICE * QUANTITY AS Revenue FROM store_orders WHERE (MERC_ID = 1) GROUP BY PRICE, QUANTITY That would be the simple way of doing ... Alternatively, I would like the query to break down the same information based on STATUS (pending, paid, shipped, etc), along with total aggregrate. Any pointers would be appreciated. H. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Howard Owens Internet Operations Coordinator InsideVC.com/Ventura County Star [EMAIL PROTECTED] AIM: GoCatGo1956 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=6 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=6 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
