WITH A AS (SELECTCUSTOMER_NAME,P_LEVEL_4_NAME,PRODUCT_NAME,PRODUCT_BATCH,SUM(END_STD_INV_NM) BENFROM ADS_DRP_INVENTORY_LIST_H WHERE 1=1AND 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 (SELECTCUSTOMER_NAME,P_LEVEL_4_NAME,PRODUCT_NAME,PRODUCT_BATCH,SUM(END_STD_INV_NM) TONGFROM ADS_DRP_INVENTORY_LIST_H WHERE 1=1AND 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) TONGFROM A LEFT JOIN BON A.CUSTOMER_NAME=B.CUSTOMER_NAMEAND A.P_LEVEL_4_NAME=B.P_LEVEL_4_NAMEAND A.PRODUCT_NAME=B.PRODUCT_NAMEAND A.PRODUCT_BATCH=B.PRODUCT_BATCH这个MONTH_CODE是202503这种格式,但是运行后下半部分B同期没有数据,实际表中是有的