求SQL语句,二表连接

Question

查找信息表的这些字段FlightNo,Leavecity(出发地),Destination(目的地),LeaveTime,LandTime,Price出发地与目的地显示地名

Answer 1

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