SQL Statement

[Krubnik]

Hi dear expert,
I've got a critical problem. Suppose we have 2 tables like following:

Flight Table:
1-FirstName
2-LastName
3-ArrivalCode
4-DepartureCode

Airlines Table:
1-AirlineCode
2-Airline

The AirlineCode goes into ArrivalCode and DepartureCode.
I want to get a query that defines Arrival Airline and
Departure Airline like this:
1-FirstName
2-LastName
3-ArrivalAirline
4-DepartureAirline

Whould you please tell that what should I do?
thanx so much,

 

[Databaseguy]

SELECT tblFlight.FirstName, tblFlight.LastName, tblAirline.Airline, tblAirline_1.Airline
FROM (tblFlight INNER JOIN tblAirline AS tblAirline_1 ON tblFlight.ArrivalCode = tblAirline_1.AirlineID) INNER JOIN tblAirline ON tblFlight.DepartureCode = tblAirline.Airline;
Tyrone Lumley
augerinn@gte.net

http://server47.hypermart.net/databaseguy