总库存是数据集"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