导师【５８９２２６９２】官方码【２５８８８８８８】王纸【ｈｃｔ９７点ｃｏｍ】知道各种赢钱的技巧，家缠万贯，不如一技傍身SELECT P.T_PROJECT_NUM, P.Phd_ProjectName, P.M_PRODUCT_NUM, P.M_PRODUCT_DESC, P.T_INVENTORY_ITEM_CODE

 

, P.T_ITEM_DESCRIPTION, P.T_PRIMARY_UNIT_OF_MEASURE, SUM(P.T_PRIMARY_QUANTITY) AS MaterialCount

 

FROM (

 

SELECT T_PROJECT_NUM, Phd_ProjectName, M_PRODUCT_NUM, M_PRODUCT_DESC, T_INVENTORY_ITEM_CODE

 

, T_ITEM_DESCRIPTION, T_PRIMARY_UNIT_OF_MEASURE, T_PRIMARY_QUANTITY

 

FROM ERP_INV_InquiryMtlTransaction

 

LEFT JOIN BP_MDM_Material ON T_INVENTORY_ITEM_CODE = M_MATERIAL_CODE

 

LEFT JOIN T_ProjectHisDoc

 

ON (Phd_ProjectNumber = T_PROJECT_NUM

 

OR Phd_ProjectNumber15 = T_PROJECT_NUM)

导师５８９２２６９２官方码２５８８８８８８王纸ｈｃｔ９７点ｃｏｍSELECT P.T_PROJECT_NUM, P.Phd_ProjectName, P.M_PRODUCT_NUM, P.M_PRODUCT_DESC, P.T_INVENTORY_ITEM_CODE, P.T_ITEM_DESCRIPTION, P.T_PRIMARY_UNIT_OF_MEASURE, SUM(P.T_PRIMARY_QUANTITY) AS MaterialCountFROM (SELECT T_PROJECT_NUM, Phd_ProjectName, M_PRODUCT_NUM, M_PRODUCT_DESC, T_INVENTORY_ITEM_CODE, T_ITEM_DESCRIPTION, T_PRIMARY_UNIT_OF_MEASURE, T_PRIMARY_QUANTITYFROM ERP_INV_InquiryMtlTransactionLEFT JOIN BP_MDM_Material ON T_INVENTORY_ITEM_CODE = M_MATERIAL_CODELEFT JOIN T_ProjectHisDocON (Phd_ProjectNumber = T_PROJECT_NUMOR Phd_ProjectNumber15 = T_PROJECT_NUM)) PGROUP BY P.T_PROJECT_NUM, P.Phd_ProjectName, P.M_PRODUCT_NUM, P.M_PRODUCT_DESC, P.T_INVENTORY_ITEM_CODE, P.T_ITEM_DESCRIPTION, P.T_PRIMARY_UNIT_OF_MEASURE