SQL 查询语句添加每日时间筛选
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/nsZg 著作权归作者所有。请勿转载和采集!