|
|
发表于 2018-6-22 12:32:40
|
显示全部楼层
|
\nselectt1.id,t1.ccode,t1.ddate,t1.cmaker,t1.cverifier, t2.mainid,t2.id,t2.cinvcode,t2.fQuantity,t2.fInQuantity,t3.cInvCode,t3.fQuantity,t3.fOutQuantity,(t3.fQuantity/t2.fQuantity) as jbyl,t4.iInvNCost, ((t3.fQuantity/t2.fQuantity)*t4.iInvNCost) as bzdwcb\nfrom PP_ProductPO t1\ninner join PP_POMain t2 on t1.id=t2.id \ninner join PP_PODetails t3 on t3.mainid=t2.mainid \ninner join Inventory t4 on t4.cInvCode=t3.cInvCode\norder by t2.mainid |
|