Multi-Month - Group by Month Query
Posted on 2010-09-23
I need a query that produces a Multi-Month By Month Grouping...
Table has entries with unique prices, and timestamps.... I need a Total Per Month, and Grouped by Month result.
Array might look like: (pseudo)
[TOTAL]  [MONTH_TIMESTAMP or MONTH NAME]
Please ask more info as I likely need to provide you more information.
ORDER (table name)
ID, SALES_PERSON_ID, TS_ENTERED, GROSS_PROFIT (fields)
USERS (table name)
I need a Query where I retrieve total of all orders within a given span of months, and the same PER A SPECIFIC SALES PERSON (see above shortened table structure)