关于sql server查询语句的写法。

Question

怎样写一个查询语句select distinct ID from TrainTime order by ID

select Station from TrainTime where S_No='1'order by ID

select Stationfrom TrainTime where D_Time='-' order by ID
怎样把这3个查询语句写为一句啊，让查询查来的结果为这3列数据。
因为我想建一个表，为3列，列名为：列车车次、起点站、终点站。
有没有大神能帮帮我，急用啊！

Answer 1

SELECT
A.ID, A.Station, B.Station
FROM (
SELECT * FROM traintime WHERE A_Time = '-'
) A LEFT JOIN (
SELECT * FROM traintime WHERE D_Time = '-'
)B ON A.ID = B.ID