SELECT eh.ExpenseDate , sum(ed.Total) from expenseheader eh inner join expensedetail ed on eh.id = ed.ExpenseHeaderID inner join expense e on e.id = ed.ExpenseID inner join expensesubgroup esg on esg.id = e.ExpenseSubGroupID inner join expensegroup eg on eg.id = e.ExpenseGroupID where month(eh.ExpenseDate) = 1 and eg.ExpenseGroupName = '¤èÒÇѵ¶Ø´Ôº' group by eh.ExpenseDate;