oracle 表合并 后有两个关键字

select * from
((select t_date,count(*) 胜 from t group by t_status,t_date having T_STATUS='胜') a
inner join (select t_date,count(*) 负 from t group by t_status,t_date having T_STATUS='负') b
on a.t_date=b.t_date) ;
合并后成
1 2015-5-9 2 2015-5-9 2
2 2015-5-10 1 2015-5-10 3

select a.t_date，a.胜,b.负 from ((select t_date,count(*) 胜 from t group by t_status,t_date having T_STATUS='胜') a
inner join (select t_date,count(*) 负 from t group by t_status,t_date having T_STATUS='负') b
on a.t_date=b.t_date) ;

join 就是把 a、b 左右合并，所以字段是相加的。
这不很正常啊。

因为你是select * from

select a.* 不就可以只显示a表字段