More than one join

[markusw]

Hi all!



I have two tables:

Flights
FlightID, From, To
1, TYO, SIN
2, LHR, JFK

Airports
AirportID, IATAcode, City
1, TYO, Tokyo
2, SIN, Singapore
3, LHR, London
4, JFK, New York

I wish to create a query which looks like this:

FlightID, From, FromCity, To, ToCity

I know how to make a join so that I get the city name from the Airports-table, but can somebody point me in the right direction on how to be able to do two joins to the same table? Or solving this in another way.

Thanks!

markus

[ranman256]

Bring down Airports table twice...

select * from Flights,Airports, Airports as Airports_1

join
Airports.airportID to Flights.FROM
Airports_1.airportID to Flights.TO

[June7]

Just pull the Airports table into the query designer window twice and click drag between fields to set link lines - delete line that may have been automatically set for the second instance of table.

[orange]

Your relationships:

   
Flights                 Airports           SecondCopyof Airports

To------------------ITACode
                      City

From -------------------------------------- ITACode
                                               City

[markusw]

Thanks a lot guys and girls! Worked!