总库存是数据集"CS"和"CSKS款式"。 后面几个空白的单元格，就是在这两个数据集里加上不同的条件：G.ZICYY0313 IN ('50') （线上的条件）G.ZICYY0313 NOT IN ('50') （线下的条件）CS的数据列：CS款式的数据列：CS数据集的语句：SELECT ZICZS0000, SUM(ZJS_TO) AS ZJS_TO, SUM(BQJJE_TO) AS BQJJE_TO, SUM(DMBTR_TO) AS DMBTR_TO, SUM(ZKZ_TO) AS ZKZ_TO FROM ( SELECT A.ZICZS0000, A.ZICZA0012, G.ZICYY0313, A.BQJJE_TO, A.DMBTR_TO, A.ZJS_TO, A.ZKZ_TO FROM "_SYS_BIC"."CB.AL.YW/ZAL_STOCK_BQPRICEJGFDS"(PLACEHOLDER."$$ZIP_STDATE$$"=>${user_date_from} ,PLACEHOLDER."$$ZIP_ENDDATE$$"=>${user_date_to}) A LEFT JOIN ( SELECT CASE WHEN ZICYY0313 IS NOT NULL THEN ZICYY0313 ELSE '未做标记单' END AS ZICYY0313, CASE WHEN ZICYY3030 IS NOT NULL THEN ZICYY3030 WHEN ZICYY3030 IS NULL THEN '无货位' END AS ZICYY3030, ZICZS0000 BM, ZICZB0000 PC FROM "_SYS_BIC"."CB.AL.YW/ZAL_STOCK_BQPRICEJGFDS_KWBS"(PLACEHOLDER."$$ZIP_STDATE$$"=>${user_date_from} ,PLACEHOLDER."$$ZIP_ENDDATE$$"=>${user_date_to})) G ON A.ZICZS0000 = G.BM AND A.ZICZB0000 = G.PC LEFT JOIN "_SYS_BIC"."CB.BL.YW/ZBL_ZDEMM012" B ON A.ZICZS0000 = B.ZICZS0000 AND A.ZICZB0000 = B.ZICZB0000 LEFT JOIN "_SYS_BIC"."ZMDYHZQ" E ON E.ZICZS0000 = A.ZICZS0000 LEFT JOIN ( SELECT COMP_CODE, ZICZB0000, ZICZA0000, ZICKA0012 AS GSRKRQ FROM "_SYS_BIC"."CB.BL.YW/ZBL_ZDEMM013" ) C ON A.COMP_CODE = C.COMP_CODE AND A.ZICZB0000 = C.ZICZB0000 AND A.ZICZA0000 = C.ZICZA0000 WHERE 1 = 1 AND A.ZJS_TO <> 0 AND LENGTH(A.ZICZB0000) > 0 AND LENGTH(A.ZICZB0001) > 0 AND A.ZJS_TO NOT IN ('0.001', '-0.001') AND A.ZICZA0004='D01' AND A.ZICZS0010 ='0001' GROUP BY ZICZS0000 ORDER BY ZICZS0000
