金蝶K3--MRP计划单--清单

select top 1000 a.*,d.*
from icmrpresult a
left outer join t_icitem e on a.fitemid=e.fitemid
left outer join seorderentry b on a.forgsaleinterid=b.finterid and a.forgentyrid=b.fentryid
left outer join seorder c on b.finterid=c.finterid
left outer join icmrpinfo d on a.frunid=d.finterid
where a.fclosetype=0 c.fbillno='SE1811012' and e.fnumber='2.200.DU5415L-0003'

 

转载于:https://my.oschina.net/ansenchina/blog/3024870