Hi,
I am a newbie to sql,I have a problem with querying the intended result.What i need is to get the SUM() of daily income,cost im my result set, but it gives me unintended result set hence it gets duplicated by GROUP BY clause.please correct my sql.
Thank you.

this is what i want

+------------+--------+------+
| date | Income | Cost |
+------------+--------+------+
| 2010-05-12...