我有两个表,一个是用户表user,一个填报工时的detail表,以此来查出当日未填报工时的人员的人数以及姓名(已经填报过的就查不出来了),但是我下面的sql语句为什么老是查出来user表中的姓名和数量;这是为什么?有谁能把帮忙写一下sql语句?
<select id="getUsersReport" resultType="com.bjpowernode.st.workbench.domain.UnfilledUserReport">
SELECT u.name AS userName, COUNT(d.id) AS value
FROM tbl_user u
LEFT JOIN tbl_detail d ON d.id = u.id AND DATE(d.create_time) = CURRENT_DATE
WHERE d.id IS NULL OR (DATE(d.create_time) = CURRENT_DATE AND d.id IS NULL)
GROUP BY u.name
</select>