MySQL - Querying tax total for each month

[Will Tomlinson]

MySQL 5

My client wants to run a report on taxes collected for a given month in a given 
year.  I have a typical orders table with an “ordertax” field and 
“orderdate” field. I’m remote right now so I can’t test this, but how 
could I spit out order totals for each month. Here’s what I’m thinking…

select month(orderdate), sum(ordertax) as totalMonthTaxes
from tblorders
where year(orderdate) = 2008
group by month(orderdate)
order by month(orderdate)

Any better ideas?

Thanks,
Will


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319534
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4