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()
原文地址: https://www.cveoy.top/t/topic/ns0x 著作权归作者所有。请勿转载和采集!