oracle空值减去一个数_减去两个值时返回空值

我正在运行一个查询,以获取特定客户机在两个时间段(7月和8月)内的总计。然后将两者相减得到差分。然而,当我减去时,即使对于这个客户端的JUL和AUG都存在值,也会得到空值。

SELECT语句的这一部分返回null值,尽管我知道值/数字存在。8月金额-7月金额作为最终结果'

我试过分别运行jul和aug表,它们确实返回了ah的sum/total。

SELECT AUG.party_name, AUG.amount - JUL.amount as Final_Result

FROM (select cl.party_name, sum(cl.amount)/1000 as amount

from CLIENT_PROFIT CL

where to_char(trade_date,'YYYYMMDD') between '20190801' and '20190830'

AND cl.party_name = 'AH'

group by cl.party_name

) AUG

LEFT JOIN

(select cl.party_name, sum(cl.amount)/1000 as amount

from CLIENT_PROFIT CL

where to_char(trade_date,'YYYYMMDD') between '20190701' and '20190731'

AND cl.party_name = 'AH'

group by cl.party_name) JUL

ON AUG.party_name = JUL.party_name

group by AUG.party_name

order by Final_Result DESC

对ah来说,8月和7月的预期结果应该是不同的