批量查询物料的最近采购价

zhou66

select * From (
select po.vbillcode,po.dbilldate, pob.nqtorigtaxprice,pob.pk_material,
        row_number() over(partition by pob.pk_material order by po.dbilldate desc) rn
from po_order_b pob
inner join po_order po on pob.pk_order =po.pk_order
where po.dr=0 and pob.dr=0
) where rn=1

game2000

可以在采购订单上，联查之前的采购价格？