[步骤]

SELECT pdbd.SupplierID,
       CONVERT(BIGINT, Sum(wppl.PutInNum))                                                                                   AS PutTotalNum,
       Sum(wppl.PutInNum * ( Isnull(pdbd.ActualProductPrice, 0) + Isnull(pdbd.UnitShipFee, 0) - Isnull(pdbd.UnitMinus, 0) )) AS PutTotalAmount
FROM   dbo.RB_WareHouse_Product_PutIn_Log (NOLOCK) wppl
       LEFT JOIN dbo.RB_Procurement_Detail_BuyList_Detail (NOLOCK) pdbd
         ON pdbd.CustomerID = wppl.CustomerID
            AND pdbd.DetailID = wppl.DetailID
            AND pdbd.SKU = wppl.SKU
            AND pdbd.ListNo = wppl.ListNo
       LEFT JOIN dbo.RB_Procurement_Detail_BuyList (NOLOCK) pdb
         ON pdb.ListNo = pdbd.ListNo
            AND pdb.P_Code = pdbd.P_Code
            AND pdb.CustomerID = pdb.CustomerID
WHERE  wppl.CustomerID = @customerId
       AND wppl.ListNo IS NOT NULL
       AND pdb.ProcPayType IS NOT NULL
       AND wppl.ListNo <> ''
       AND wppl.PutInNum > 0
GROUP  BY pdbd.SupplierID; 

[结果]

[期望]

1.改善SQL 提醒性能，增加一些必要的逻辑。2。是否可以考虑读库查询