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