这是我在知道两个站名时查询代码 select a.TrainId as 车次,a.StationName as 起始站,b.StationName as 终点站, convert(varchar,a.ArriveTime,108) as 到站时间,convert(varchar,b.ArriveTime-a.LeaveTime,108) as 运行时间, b.Distance-a.Distance as 距离km,b.Date as 日期 from dbo.Trains a inner join dbo.Trains b on a.TrainId=b.TrainId and a.StationName='郑州' and b.StationName='北京西'
select a.TrainId as 车次,a.StationName as 起始站,b.StationName as 终点站,
convert(varchar,a.ArriveTime,108) as 到站时间,convert(varchar,b.ArriveTime-a.LeaveTime,108) as 运行时间,
b.Distance-a.Distance as 距离km,b.Date as 日期
from dbo.Trains a inner join dbo.Trains b
on a.TrainId=b.TrainId and a.StationName='郑州' and b.StationName='北京西'