求一sql语句

Question

现有2个表：
１、t_1
station_id  station_name   
100101 aa
100102 bb 2.t_2
airline_id station_id  station_begin_id  station_end_id
1    100101        100101         100102      要求得到结果如下：
airline_id   station_name  station_begin_name  station_end_name  
1              aa          aa                 bb   

Answer 1

select airline_id,station_name,station_name  station_begin_name,station_name  station_end_name  from t_2,t_1
where t_2.station_id=t_1.station_id;

Answer 2

昏了，改一下：select t.airline_id,t1.station_name,t1.station_name  station_begin_name,t2.station_name  station_end_name  from t_2 t,t_1 t1,t_1 t2
where t.station_id=t1.station_id 
and t.station_id=t2.station_id ;

Answer 3

这种方法不行，返回来的station_begin_name  station_end_name 都是aa

Answer 4

select t.airline_id,t1.station_name,t2.station_name  station_begin_name,t3.station_name  station_end_name  from t_2 t,t_1 t1,t_1 t2,t_1 t3
where t.station_id=t1.station_id 
and t.station_begin_id=t2.station_id 
and station_end_id=t3.station_id ;