用友U8按出入库类别统计数量、金额

其他入库单统计：

SELECT

(

SELECT cRdName FROM Rd_Style WHERE cRdCode = RdRecord08.cRdCode

) AS 入库类别,

SUM(iQuantity) AS 数量,

SUM(iPrice) AS 金额

FROM RdRecord08

JOIN dbo.rdrecords08

ON rdrecords08.ID = RdRecord08.ID

AND dDate

BETWEEN '2022-01-01' AND '2022-12-31'

GROUP BY cRdCode

其他出库单统计：

SELECT (

SELECT cRdName FROM Rd_Style WHERE cRdCode = RdRecord09.cRdCode

) AS 出库类别,

SUM(iQuantity) AS 数量,

SUM(iPrice) AS 金额 FROM RdRecord09 JOIN dbo.RdRecords09 ON rdrecords09.ID = RdRecord09.ID

AND dDate BETWEEN '2022-01-01' AND '2022-12-31'

GROUP BY cRdCode