34,576
社区成员
发帖
与我相关
我的任务
分享
select a.lineno,a.fromcityid,a.tocityid,
b.citname as fromcityname,b.cityenname as fromcityenname,
c.citname as tocityname,c.cityenname as tocityenname
from 航线表 a
left join 城市表 b on a.fromcityid=b.cityid
left join 城市表 c on a.tocityid=c.cityid
select a.lineno,a.fromcityid,a.tocityid,b.citname,b.cityenname,c.citname,c.cityenname
from 航线表 a
left join 城市表 b on a.fromcityid = b.cityid
left join 城市表 c on a.tocityid = c.cityid