我想你在哪里
from calender c
应该是
from calender
而且
left join attandances a
left join attandances on calender.cdate = attandances.date