我有两张桌子,一张叫做附件,用来存储打卡和打卡记录,另一张是日历,我有所有的日期
附件:
日历:
我想获取员工未在我的查询中输入的月份日期,如下所示:
select a.employeeID, c.cdate
from calendar c
left join attandances a on (c.cdate = a.date)
where a.date is null
and a.employeeID='1'
and c.cdate between '2021-12-01' and '2021-12-31'
但当我执行时,它会返回0行。有什么建议我遗漏了什么吗?
