SELECT IF(s.`name` != '',s.`name`,w.staffname) as '姓名', SUM(w.money) as '当月工资' FROM wages w, staff s WHERE s.id = w.staffid AND ...
確定! 回上一頁