Re: Return 0 for data with no matching values

[Peter Brawley]

Your left join is backwards.

select year(cal.date), count(b.birthdate)
from calendar c
left join birthdates b on c.date=b.date
group by year(cal.date);