找了很久答案了，不成功，没用，试着加了在个个地方加了别名，，难受

如下sql

select number from(select sum(number) from

(select buy_uid, sum(number) from order_cclcoin GROUP BY sale_uidas

union ALL

select sale_uid, sum,(number) from order_cclcoin GROUP BY buy_uid)#as a

group by buy_uid as a);

崩溃。。。。