改了sqlSELECT Pu_ReqSub.SSaOrderNO,       Pu_ReqSub.SItemNO AS SItemSubNO,       Pu_ReqSub.SItemName AS SItemSubName,       Pu_ReqSub.SItemSpec AS SItemSubSpec,       Pu_ReqSub.SItemPhoto AS SItemSubPhoto,       Pu_ReqSub.SQtys AS SQtys_Req,       B.SQtys_ZReq,       ISNULL(A.SQtys_ALL,0) AS SQtys_ALL,      ISNULL(B.SQtys_ZReq-A.SQtys_ALL,0) AS SQtys_ZReq_QL,       Ba_Unit.SUnit,       Wh_WareHouse.SWareHouse,       It_ItemClass.SItemClass,       Pu_Supply.SSupplyName,       Pu_Req.FIDFROM dbo.Pu_ReqSub    LEFT JOIN dbo.Pu_Req        ON Pu_Req.SID = Pu_ReqSub.SPID    LEFT JOIN Pu_OrderSub        ON Pu_OrderSub.SPuReqSubID = Pu_ReqSub.SID    LEFT JOIN Pu_Order        ON Pu_Order.SID = Pu_OrderSub.SPID    LEFT JOIN Pu_Supply        ON Pu_Supply.SID = Pu_Order.SSupplyID    INNER JOIN dbo.It_ITem        ON It_ITem.SID = Pu_ReqSub.SItemID    LEFT JOIN dbo.Ba_Unit        ON It_ITem.SUnitID = Ba_Unit.SID    LEFT JOIN It_ItemClass        ON It_ItemClass.SID = dbo.Pu_ReqSub.SItemClassID    LEFT JOIN dbo.Wh_WareHouse        ON Wh_WareHouse.SID = It_ITem.SWareHouseID    LEFT JOIN    (        SELECT SItemID,               SUM(SQtys_Current) AS SQtys_ALL        FROM dbo.Wh_CurStock        WHERE ISNULL(SItemStatusID, 0) = 1              AND SWareHouseID IN                  (                      SELECT SID FROM dbo.Wh_WareHouse WHERE ISNULL(SIsPlan, 0) = 1                  )        GROUP BY SItemID    ) A        ON A.SItemID = Pu_ReqSub.SItemID    LEFT JOIN    (        SELECT SItemID,               SUM(SQtys) AS SQtys_ZReq        FROM Pu_ReqSub            LEFT JOIN dbo.Pu_Req                ON Pu_Req.SID = dbo.Pu_ReqSub.SPID        WHERE Pu_Req.FID IN ('${月度计划}')        GROUP BY SItemID    ) B        ON B.SItemID = dbo.Pu_ReqSub.SItemIDWHERE Pu_Req.FTabName = 'PL_ProjSA'      AND Pu_Req.FID IN ('${月度计划}')ORDER BY Pu_ReqSub.SSaOrderNO,SItemSubNO

条件汇总

select 

你原来的代码

from 表名称

where 条件

union all

/*注意这个里面，要把你第一段所有列名称与类型保证一致，没有的话直接比如'' as 订单号*/

/*第一段如果某一列是文本格式，你就直接用空，如果是数字类型，你不需要的话，只是为了占位

直接用0 as 欠料数量*/

select 

sum(需求数量) as 需求数量

from 表名称

where 条件和上面保持一样

group by 字段名称