UPDATE b set b.fentryselfb0470=d.fprice
from icstockbill a inner join icstockbillentry b on a.finterid=b.finterid
left join (select top 100 percent * from icpurchaseentry order by finterid,fitemid desc) d on b.fitemid=d.fitemid
inner join icpurchase c on d.finterid=c.finterid
where a.ftrantype='24' and a.fdate>='2017-01-01 00:00:00.000'and a.fdate<='2018-02-03 00:00:00.000'

以上语句执行后，为什么生产领料单取的发票价，有的的不是最新发票单价【生产领料表体新增一列“发票价 b.fentryselfb0470”】