WITH A AS (

SELECT

CUSTOMER_NAME,

P_LEVEL_4_NAME,

PRODUCT_NAME,

PRODUCT_BATCH,

SUM(END_STD_INV_NM) BEN

FROM ADS_DRP_INVENTORY_LIST_H 

WHERE 1=1

AND MONTH_CODE = '${replace(P_S_DATE,"-","")}'

AND CUSTOMER_NAME = '${P_CUSTOMER_NAME}'

AND F_CLASS in( '${LEI}')

AND P_LEVEL_3_NAME = '${ty}'

GROUP BY 

CUSTOMER_NAME,

P_LEVEL_4_NAME,

PRODUCT_NAME,

PRODUCT_BATCH

),B AS (

SELECT

CUSTOMER_NAME,

P_LEVEL_4_NAME,

PRODUCT_NAME,

PRODUCT_BATCH,

SUM(END_STD_INV_NM) TONG

FROM ADS_DRP_INVENTORY_LIST_H 

WHERE 1=1

AND MONTH_CODE = '${FORMAT(YEARDELTA(P_S_DATE,-1),"yyyyMM")}'

AND CUSTOMER_NAME = '${P_CUSTOMER_NAME}'

AND F_CLASS in( '${LEI}')

AND P_LEVEL_3_NAME = '${ty}'

GROUP BY 

CUSTOMER_NAME,

P_LEVEL_4_NAME,

PRODUCT_NAME,

PRODUCT_BATCH

)

SELECT 

A.CUSTOMER_NAME,

A.P_LEVEL_4_NAME,

A.PRODUCT_NAME,

A.PRODUCT_BATCH,

A.BEN,

NVL(B.TONG,0) TONG

FROM A 

LEFT JOIN B

ON A.CUSTOMER_NAME=B.CUSTOMER_NAME

AND A.P_LEVEL_4_NAME=B.P_LEVEL_4_NAME

AND A.PRODUCT_NAME=B.PRODUCT_NAME

AND A.PRODUCT_BATCH=B.PRODUCT_BATCH

这个MONTH_CODE是202503这种格式，但是运行后下半部分B同期没有数据,实际表中是有的