可能是這樣的吧!你自己再改一下
select a.*,b.[StationName] as [StartStationName],c.[StationName] as
[EndStationName]
from [E_Train] a inner join [E_Station] b on
a.[startStationID]=b.[StationID] inner join [E_Station] c on
a.[EndStationID]=c.[StationID]
where condition1