给以下sql添加 时间为每天SELECT sufull_name sumobile sdname FROM sys_user su INNER JOIN sys_dept sd ON sdid =sudept_id LEFT JOIN work_record wr ON wrcreate_by = suidWHERE wrcreate_by IS NULL
SELECT
su.full_name,
su.mobile,
sd.name
FROM
sys_user su
INNER JOIN sys_dept sd ON sd.id =su.dept_id
LEFT JOIN work_record wr ON wr.create_by = su.id
WHERE
wr.create_by IS NULL AND DATE(su.create_time) = CURDATE()
原文地址: http://www.cveoy.top/t/topic/ci9l 著作权归作者所有。请勿转载和采集!