56,682
社区成员
发帖
与我相关
我的任务
分享
SELECT
udate.RepDate,
IFNULL(ct.ctCount,0),
IFNULL(tk.tkCount,0)
FROM u_date AS udate
LEFT JOIN (
SELECT
DATE(task.CREATE_TIME) AS dt,
COUNT(0) AS ctCount
FROM e_escort_task AS task
GROUP BY dt
) AS ct ON udate.RepDate = ct.dt
LEFT JOIN (
SELECT
DATE(task.TASK_TIME) AS dt,
COUNT(0) AS tkCount
FROM e_escort_task AS task
GROUP BY dt
) AS tk ON udate.RepDate = tk.dt
WHERE udate.RepYear = 2018 AND udate.RepMonth = 9