代码如下

select a.settle_day, a.'销售额度', b.'利润金额'

from

(select ,settle_day,sum(sum_oil_volume) as "销售额度" from app_b04.dit_ci00004_hy where  oil_type = "301001"   group by settle_day

)a

full join

(select sum(sum_oil_volume) as "利润金额",settle_day from app_b04.dit_ci00004_hy where  oil_type = "301002" group by settle_day

)b

on a.settle_day =b.settle_day

group by a.settle_day