查询人员最后一次发工资
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.Pr
原创
2011-05-03 17:15:00 ·
756 阅读 ·
0 评论