Flight Instance table
I am developing a Web-based GUI for a flight reservation system. The following select statement is used to find the selected flights on a given date:
------------------------------------------------------------------------------------------------------
select distinct flight_no, origin, dept_time, destination, arri_time, flight_date
from flight_instance
where orig = 'AMS and destination = 'LHR'
and flight_date = '28-DEC-06'
order by dept_time;
------------------------------------------------------------------------------------------------------
Basically straightfoward, however, I need to display the outbound and return flight. How would the statement look like in this case?
Thank you!