车次
车辆类型
始发站
终点站
发站
发时
到站
到时
里程
历时
select c1.theNum, c1.theType, c1.sTitle, c1.eTitle, c2.sTitle, c2.sTime, c3.sTitle, c3.eTime, c3.Mileage, c2.Mileage, c3.Days, c2.Days from Long_traininfo as c3 inner join (Long_traininfo as c2 inner join Long_trainlist as c1 on c2.theNum = c1.theNum) on c3.theNum = c1.theNum and c3.sTitle = c1.eTitle where c2.sTitle like '%俑%' order by c1.theNum;