单独查都是可以查出数据的，但是left join 后同期就没数了

WITH A AS (

select 

T_PROVINCE,

T_LEVEL_4_NAME,

T_PROVINCE_NAME,

SUM(TASK_AM_SUM)/10000 TASK_AM_SUM,

SUM(TZ_AM_SUM)/10000 TZ_AM_SUM,

SUM(REAL_AM_SUM)/10000 REAL_AM_SUM,

(SUM(TZ_AM_SUM) + SUM(REAL_AM_SUM))/10000 WANCHENG,

SUM(TASK_AM_YEAR_SUM) YEAR_TASK

from ADS_DRP_QDLX_P_SUM

WHERE 1=1

AND YEAR_ID = '2025'

AND MONTH_ID <= '03'

and T_LEVEL_4_NAME ='OTC-东北省区'

GROUP BY

T_PROVINCE,

T_LEVEL_4_NAME,

T_PROVINCE_NAME

),

B AS (

select 

T_PROVINCE,

T_LEVEL_4_NAME,

T_PROVINCE_NAME,

SUM(TASK_AM_SUM)/10000 TASK_AM_SUM,

SUM(TZ_AM_SUM)/10000 TZ_AM_SUM,

SUM(REAL_AM_SUM)/10000 REAL_AM_SUM,

(SUM(TZ_AM_SUM) + SUM(REAL_AM_SUM))/10000 WANCHENG

from ADS_DRP_QDLX_P_SUM

WHERE 1=1

AND YEAR_ID = '2024'

AND MONTH_ID <= '03'

and T_LEVEL_4_NAME ='OTC-东北省区'

GROUP BY

T_PROVINCE,

T_LEVEL_4_NAME,

T_PROVINCE_NAME

)

SELECT

A.T_PROVINCE,

A.T_LEVEL_4_NAME,

A.T_PROVINCE_NAME,

NVL(A.TASK_AM_SUM,0) TASK_AM_SUM,

NVL(A.TZ_AM_SUM,0) TZ_AM_SUM,

NVL(A.REAL_AM_SUM,0) REAL_AM_SUM,

NVL(A.WANCHENG,0) BQ,

NVL(A.YEAR_TASK, 0) YEAR_TASK,

NVL(B.WANCHENG,0) TQ

FROM A left  JOIN B

ON A.T_PROVINCE = B.T_PROVINCE

AND A.T_LEVEL_4_NAME = B.T_LEVEL_4_NAME

AND A.T_PROVINCE_NAME = B.T_PROVINCE_NAME

合起来就没数了