1,216
社区成员
发帖
与我相关
我的任务
分享
SELECT T2.日期,
IIf(IsNull(T1.人数),0,T1.人数) AS 人数
FROM 日历 AS T2
LEFT JOIN (
SELECT 日期, Count(*) AS 人数
FROM 表
WHERE 是否加班 = True
GROUP BY 日期
) AS T1
ON T2.日期 = T1.日期
WHERE T2.日期 BETWEEN #2015-1-1# AND #2015-1-10#
ORDER BY T2.日期