成本计算

select t4.FNUMBER,t5.FNAME,t6.FNUMBER,t7.FNAME,t3.* from T_CB_PROORDERINFO t1 inner join T_CB_PROORDERDIME t2 on t1.FPRODUCTDIMEID=t2.FPRODUCTDIMEID
inner join t_cb_costmatterial t3 on t1.FID=t3.FID
inner join T_CB_COSTCENTER t4 on t2.FCOSTCENTERID=t4.FCOSTCENTERID
inner join T_CB_COSTCENTER_L t5 on t2.FCOSTCENTERID=t5.FCOSTCENTERID
inner join T_BD_MATERIAL t6 on t3.FMATERIALID=t6.FMATERIALID
inner join T_BD_MATERIAL_L t7 on t3.FMATERIALID=t7.FMATERIALID