查询人员最后一次发工资

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.ProsionCode)

 

查询的结果: