我又来啦,嘿嘿记录一下当时的一个思路:
相关表:
DWR_IMPORTED_PRODUCT_WAOK (收集原始出入库数据);
DWR_WAOK_RK(收集入库的数据);
DWR_IMPORTED_PRODUCT_WAOK_TMP2(各产品入库汇总表);
DWR_INVENTORY_WAOK(库存汇总表);
------单独将入库的产品打包并创建DWR_WAOK_RK表中:
CREATE TABLE DWR_WAOK_RK AS
SELECT *
FROM DWR_IMPORTED_PRODUCT_WAOK
WHERE TYPE_STYLE = 1; ---值 1 代表入库
------将相同的入库产品进行合计汇总到各产品入库汇总表上 :
INSERT INTO DWR_IMPORTED_PRODUCT_WAOK_TMP2
(STYLE_NUMBER,
S_CODE,
M_CODE,
L_CODE,
XL_CODE)
SELECT S.STYLE_NUMBER,
SUM(S.S_CODE),
SUM(S.M_CODE),
SUM(S.L_CODE),
SUM(S.XL_CODE)
FROM DWR_WAOK_RK S
WHERE 1 = 1
GROUP BY S.STYLE_NUMBER;
COMMIT;
------第一种情况,将原有产品入库数