22,209
社区成员
发帖
与我相关
我的任务
分享
SELECT a.e_employee_id, a.e_employee_no, a.e_full_name,
e.e_employee_id, e.e_attendance_date,e.e_shift_id,e.e_late_in,
e.e_early_out,e.e_break_late_in,e.e_break_early_out,e.e_absence,
e.e_irregular,e.e_leave_code,e.e_total_raw_ot_time,e.e_total_rounded_ot_time,
e.e_total_raw_working_hours,e.e_approved_ot,
c.e_badge_number,b.e_join_date
FROM ev_employee a
INNER JOIN e_tms_attendance_view e
ON a.e_employee_id =e.e_employee_id
AND e.e_attendance_date>= '2002-12-01 00:00:00.000'
AND e.e_attendance_date <= '2009-01-01 00:00:00.000'
INNER JOIN ev_tms_employee c
ON a.e_employee_id =c.e_employee_id
INNER JOIN ev_tms_emp_sch_grp_change_tracker d
ON a.e_employee_id =d.e_employee_id
AND d.e_current_schedule_group=1
INNER JOIN ev_emp_job b
ON a.e_employee_id =b.e_employee_id
AND b.e_employment_status =1
WHERE a.e_deleted =0;
最好给出完整的表结构,测试数据,计算方法和正确结果.