為什麼會有兩個日期了-oracle 表合並 後有兩個關鍵字

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) ;