Re: [PHP] sql query with join and same column twice...

Please try select dest.dest_name, air.name as airport1, air2.name as airport2 from destination, airport air, airport air2 where dest.airport_dep_id_id=air.airport_id and dest.airport_arr_id=air2.airport_id; you can use the same table as manu times as you like in sql. I

[PHP] sql query with join and same column twice...

Hello, Here are 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