Page 1 of 1

MYSQL sales report query

Posted: Thu Mar 11, 2010 7:55 am
by krishnan
SELECT SUM(ORDER_PRODUCTS_TABLE.price) AS TOTAL_SALE,
DATE_FORMAT(ORDER_DETAILS.created_datetime, '%b') AS month,
DATE_FORMAT(ORDER_DETAILS.created_datetime, '%c') AS month_no
FROM ORDER_PRODUCTS AS ORDER_PRODUCTS_TABLE
LEFT OUTER JOIN ORDER_DETAILS AS ORDER_DETAILS ON(ORDER_PRODUCTS_TABLE.order_id = ORDER_DETAILS.order_id)
WHERE
YEAR(ORDER_DETAILS.created_datetime) = (GIVE CURRENT YEAR)
GROUP BY month ORDER BY ORDER_DETAILS.created_datetime

Re: MYSQL sales report query

Posted: Thu Mar 11, 2010 10:41 am
by AbraCadaver
That's very nice.

Re: MYSQL sales report query

Posted: Thu Mar 11, 2010 12:18 pm
by mikosiko
AbraCadaver wrote:That's very nice.
:) Nah... is a subliminal way to teach how to "not" write a select :wink: I'm feeling grateful now :mrgreen:

Re: MYSQL sales report query

Posted: Thu Mar 11, 2010 1:05 pm
by John Cartwright
Either start writting descriptive posts, or don't post at all. :banghead: