求SQL语句,二表连接
0
最佳答案
0
select FlightNo,
(select CityName from B where B.id=A.airwaysid) as Leavecity,
(select CityName from B where B.id=A.Destination) as Destination
LeaveTime,LandTime,Price
from A
收获园豆：5
select f.FlightNO,(select CityName from CityInfo where CityInfo.Id =f.LeaveCity) as 出发地,(select CityName from CityInfo where CityInfo.Id=f.Destination) as 目的地 from FlightInfo as f,CityInfo
这个与你的语句没什么错误吧,错了结果有350条,可我数据库里就14条的,而且出发地与目的地都是一样的
抱歉后面多加了个表名
