代码如下

select a.settle_day, a.计划, b.销售金额, c.利润

from

((select sum(sum_tr) as "计划" ,settle_day from app_b04.dit_ci00004_hy where  sale_type = "301001" group by settle_day 

)a

full join

(select sum(sum_tr) as "销售金额",settle_day from app_b04.dit_ci00004_hy where  sale_type = "301002"  group by settle_day 

)b

on a.settle_day =b.settle_day

full join

(select sum(sum_tr) as "利润",settle_day from app_b04.dit_ci00004_hy where  sale_type = "301003"  group by settle_day 

)c

on a.settle_day =c.settle_day)

 where a.settle_day = today()