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 = '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(

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 = '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.TONG

FROM A

FULL JOIN

B ON A.CUSTOMER_NAME = B.CUSTOMER_NAME

AND A.PRODUCT_BATCH = B.PRODUCT_BATCH

AND A.PRODUCT_NAME = B.PRODUCT_NAME

数据问题没办法用左连接，所以用的full join但是求出来上面有一大片空值，能不能让这些空值显示自己原本的数据呀