一个有点难度的Sql问题
两个表
表1
id,车号,顺序,站名
1,"1",1,"a"
2,"1",2,"b"
3,"1",3,"c"
4,"1",4,"d"
5,"1",5,"e"
6,"1",6,"f"
7,"1",7,"g"
8,"1",8,"h"
9,"2",1,"f"
10,"2",2,"i"
11,"2",3,"j"
12,"2",4,"k"
13,"2",5,"l"
14,"2",6,"m"
表2
id,站名,车号
1,"a","1"
2,"b","1"
3,"c","1"
4,"d","1"
5,"e","1"
6,"f","1"
7,"f","2"
8,"g","1"
9,"h","1"
10,"i","2"
11,"j","2"
12,"k","2"
13,"l","2"
14,"m","2"
我要查询 从 a站 到 m站
应该怎么做车?
要求能回答出 做哪几路车?在什么站转车? 最短路径(这个不需要加权运算)
说明
表1中的顺序是指 站台的顺序
有兴趣的朋友讨论讨论
:)