select 取一个sum（总值）from
(SELECT '原始保费',SUM(COALESCE(PREMIUM *COINSRATE*EXCHRATE/100,0)) as baofei
FROM WEB_LIST_CMAINORIGIN d
WHERE STATDATE>=to_date('2021-10-24','yyyy-mm-dd')
AND STATDATE<=to_date('2021-10-24','yyyy-mm-dd')
and comcode like '65%'
)a,
left join
(SELECT'批改保费', SUM(COALESCE(CHGPREMIUM*COINSRATE*EXCHRATE/100,0)) as pidan
FROM WEB_LIST_PMAIN c
WHERE STATDATE>=to_date('2021-10-24','yyyy-mm-dd')
AND STATDATE<=to_date('2021-10-24','yyyy-mm-dd')
and comcode like '65%'
)b
where 1=1
group by a.comcode,b.comcode
各位大神哪里出现问题了 目的：原始保费+批改保费

sum(baofei) 你没“总值”这个字段