上面的是人员表 select * from PM_Prosion 这是一个工资表 select * from PM_PayOff 查询结果是:人员的最后一次发工资 select b.ProsionName,a.PayDate,a.PayPrice from PM_PayOff a LEFT JOIN PM_Prosion b ON a.ProsionCode = b.ProsionCode where a.PayDate = (select Max(c.PayDate) from PM_PayOff c where a.ProsionCode = c.Prosi...