求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 DestinationLeaveTime,LandTime,Pricefrom A