#始:广州 经:长沙
SELECT AutoID,tb_train_transfer.`ScheduleID`,(Distance-EndGap) as length FROM `tb_train_schedule` INNER JOIN tb_train_transfer on tb_train_schedule.`AutoID`=tb_train_transfer.`ScheduleID`
where tb_train_schedule.`StartStationID`=(select AutoID from tb_train_station where Name like "%广州%")
and tb_train_transfer.`StationID`=(select AutoID from tb_train_station where Name like "%长沙%")
#on 来关联,where 来确定
MySQL-inner join
最新推荐文章于 2024-02-04 06:30:00 发布