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()

给以下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

原文地址: http://www.cveoy.top/t/topic/ci9l 著作权归作者所有。请勿转载和采集!

免费AI点我,无需注册和登录