SELECT a.`AT_WORKDAY`,a.`AT_ACTUAL`,a.`AT_COMLEAVE_NOPAID`,p.`INSURANCE_BASE`,p.`MOUTH_MONE`,e.`LUNCH_PAY`FROM attendance AS a,hr_payrolls AS p,emp_sub_mouth AS e WHERE a.`EMP_ID`=p.`EMP_ID`=e.`EMP_ID` AND e.`SUB_MOUTH`=a.`AT_DATE`='2011-05'
添加回答
舉報
0/150
提交
取消