Pinback

Thx , you're right. But in this case this isn't the prob...

As I described I need the sum of each single day of all days per month.
I guess I need something like DISTINCT, JOIN and SUM..but I don't know how 😞

Hi,

I want to summarise my monthly sales results per day (see Attachment).

That's my current code:

SELECT sum FROM tb WHERE year=selected_year AND month=selected_month ORDER BY day ASC

But instead of showing each single sale I want to summarise all sales per day and show the total sum.
How can I do this?

THX
Simon