Quoting "Owens, Howard" <[EMAIL PROTECTED]>: > > 1) How many orders have been place > 2) What the total income from those orders ad up to.
> SELECT COUNT(STATUS) AS TotalOrders, PRICE * QUANTITY AS Revenue > FROM store_orders > WHERE (MERC_ID = 1) > GROUP BY PRICE, QUANTITY > Alternatively, I would like the query to break down the same information > based on STATUS (pending, paid, shipped, etc), along with total aggregrate. I think you mean: SELECT STATUS, COUNT(STATUS) AS TotalOrders, SUM(PRICE * QUANTITY) AS Revenue FROM store_orders WHERE MERC_ID = 1 GROUP BY STATUS Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
