i've been playing around to find a solution and going through forums but no joy. hopefully you can help
I have a db of customer deliveries by month. the delivery table will look something like:
dmonth customerid qty
mar-10 1 1
jun-10 2 1
mar-10 1 2
sep-10 1 1
Obviously i then have another table with all the customer info, in particular name and id.
Additionally I have a table that gives me months and quarters:
What i want to get at is customer orders by customer and quarter. I can get total orders by quarter by joining the monthquarter table and the delivery table, but i cant figure out how to get it by customer as well.
Hopefully i've explained it clearly, appreciate any help.