搜索 |
SELECT * FROM (
SELECT
row_number() OVER (ORDER BY PROD_LINE_NAME) AS mynum,
PROD_LINE_NAME LLINE, --产线名称
SG_SIGN LSG_SIGN, --钢种
SUM(INVENT_COUNT_BLANK) AS LPLKC, --坯料成库存量
SUM(INVENT_COUNT_FINISHED) AS LCPKC --成品库存量
FROM GBGZ00.TWHKC02_ADS
WHERE DATE = '${DATE}' and PROD_LINE_NAME in ('A线','B线','大棒','外卖')
GROUP BY
PROD_LINE_NAME,SG_SIGN
) LB
FULL JOIN (
SELECT
row_number() OVER (ORDER BY PROD_LINE_NAME) AS mynum,
PROD_LINE_NAME RLINE, --产线名称
SG_SIGN RSG_SIGN, --钢种
SUM(INVENT_COUNT_BLANK) AS RPLKC, --坯料成库存量
SUM(INVENT_COUNT_FINISHED) AS RCPKC--成品库存量
FROM GBGZ00.TWHKC02_ADS
WHERE DATE = '${DATE}' and PROD_LINE_NAME in ('小棒','中棒')
GROUP BY
PROD_LINE_NAME,SG_SIGN
) RB ON LB.mynum=RB.mynum