求一sql语句

[huo789]

现有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

[njhart2003]

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;

[njhart2003]

昏了，改一下：

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 ;

[huo789]

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

[waterfirer]

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 ;

[huo789]

多谢，问题已经解决
马上给分