Re: 2 tables, joins and same name...

Marc André Paquin wrote:

> Here is 2 tables:
>
> airport
> ---------
> airport_id
> name
> code
> city_id
>
> destination
> -----------
> destination_id
> dest_name
> ...
> airport_dep_id // using airport.airport_id (departure)
> airport_arr_id // using airport.airport_id has well (arrival)
>
> I have 2 columns in the second table that uses the same name column in
> the first table...
>
> I dont know how to formulate my SQL query... I want to select the
> destinations in the destination table with not the ID of each airport
> but their names. I can do a join with one but with the second one, I
> get no results... And this is confusing!

May be I'm wrong, but I think you mean something like this one

select dest_name
, air1.name as airport1
, air2.name as airport2
from destination
join airport as air1
on air1.airport_id = destination.airport_dep_id
join airport as air2
on air2.airport_id = destination.airport_arr_id

Thomas