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 = '202403'AND CUSTOMER_NAME = '广州' AND F_CLASS in( '一级商业','二级商业')AND P_LEVEL_3_NAME = 'A类'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 = '202503'AND CUSTOMER_NAME = '广州' AND F_CLASS in( '一级商业','二级商业')AND P_LEVEL_3_NAME = 'A类'GROUP BY CUSTOMER_NAME,P_LEVEL_4_NAME,PRODUCT_NAME,PRODUCT_BATCH)SELECT A.CUSTOMER_NAME,A.PRODUCT_BATCH,A.PRODUCT_NAME,A.P_LEVEL_4_NAME,A.BEN,B.TONGFROM AFULL JOINB ON A.CUSTOMER_NAME = B.CUSTOMER_NAMEAND A.PRODUCT_BATCH = B.PRODUCT_BATCHAND A.PRODUCT_NAME = B.PRODUCT_NAME数据问题没办法用左连接,所以用的full join但是求出来上面有一大片空值,能不能让这些空值显示自己原本的数据呀