该文提供了2022年全年RdRecord08和RdRecord09表中的入库和出库单统计数据，按类别分组并计算了数量和金额。通过对cRdCode的查询获取入库类别和出库类别，时间范围限定在2022年1月1日至12月31日之间。
其他入库单统计：
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
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
