SELECT ar.employee_id, ar.attendance_date, ar.clock_in_time, ar.clock_out_time
FROM attendance_records ar
INNER JOIN employees e ON ar.employee_id = e.employee_id
WHERE e.department_id = 101 AND ar.attendance_date BETWEEN ‘2023-01-01’ AND ‘2023-01-31’;
利唐i人事HR社区，发布者：hi_ihr，转转请注明出处：https://www.ihr360.com/hrnews/20241224192.html
