Hi All,

I have two tables look like following,

TABLE 01 has three columns flightNO,dest_airport_code,Origin_airport_code
TABLE 02 has two columns airport_code,airport_name

I want to retrive flightNO,dest_airport_code,airport_name,Origin_air port_code,airport_name

airport_name after the dest_airport_code is the relavent airport name and airport_name after the origin_airport_code means the relavent origin airport name.How can I retrive these columns.

please help me.

use WHERE clause to join the three tables

I used it as follows


select flightNo,origin_airport_code,airport_name "origin" ,dest_airport_code,airport_name "dest"
from table_01 a,table_02 b
where b.airport_code=a.origin_airport_code and b.airport_code=a.dest_airport_code;


but it doesnt retrive any row.

your SQL only returns rows when a.origin_airport_code=a.dest_airport_code;

select flightNo,origin_airport_code,airport_name "origin" ,dest_airport_code,airport_name "dest"
from table_01 a,table_02 b1, table_02 b2
where <you fill in missing details>

thank you so much!!! it works !!.

That is why I said THREE tables in previous response

yes.now I can understand it.first I was confused where is the THREE tables.now it is ok Thank you again.