e-hr系统sql查询语句（E-HR System SQL query statement）.docVIP

e-hr系统sql查询语句（E-HR System SQL query statement） The current status is regular employee C_EMPLOYEESTATUS=2 In accordance with the staff number from small to large order order by c_code ASC Brush degrees awarded to the state as empty Select, C_DEGREECOUNTRY, e.*, edu.rowid, from, tb_inf_empeducation, edu, tb_inf_employee, e Where edu.c_degree is not null and edu.C_DEGREECOUNTRY is null and e.c_employeeid=edu.c_empoid and e.c_knowledge in (1_1,1_2,1_3,1_4,1_5,2_1,2_2,2_3,2_4,2_5,2_6,2_7,2_8,4_1,4_2,4_3) And C_EMPLOYEESTATUS=2 Brush your major for nothing Select, edu.C_SPECIALITY, e.*, edu.rowid, f