sql优化结果核对有误
-- 明细部分
SELECT
a.comp_code,
a.day_fee,
b.month_fee,
b.order_num
FROM
galaxydw.bi_platform_income_info a,
galaxyolap.bi_platform_income_sum b
WHERE
a.comp_code = b.comp_code
AND a.fee_type = b.fee_type_code
AND a.income_date = b.income_date
AND a.fee_type='PTSUM'
AND substr(cast(a.income_date as string),1,10)= '2017-05-23'
union all
-- 汇总部分
SELECT
'yimidida'as comp_code,
sum(a.day_fee) as day_fee,
sum(b.month_fee) as month_fee,
0 as order_num
FROM
galaxydw.bi_platform_income_info a,
galaxyolap.bi_platform_income_sum b
WHERE
a.comp_code = b.comp_code
AND a.fee_type = b.fee_type_code
AND a.income_date = b.income_date
AND a.fee_type='PTSUM'
AND substr(cast(a.income_date as string),1,10)= '2017-05-23'
如何优化这个sql,同样数据源,一个select查出明细和汇总在一起?