my table design is
date income expenses 2011-08-5 1000 500 2011-09-6 7000 400 2011-10-7 2000 300
I have daily expenses and Income in the above table.I need to retrieve monthly(sum of daily) income and expenses for particular year.
How should i write query for that .
Pls help me
Thanks in advance