passenger.passport_info, airline.description, flight.number from (Frontpage web hosting) reservation inner join passenger
passenger.passport_info, airline.description, flight.number from reservation inner join passenger on reservation.passenger_id = passenger.id inner join flight on reservation.flight_id = flight.id inner join airline on flight.airline_id = airline.id where reservation.flight_id = 34 order by reservation.seat Currently, this flight is not very popular, and it looks like Peter and Annie will be able to chat together: All Persons on a Flight In the unlikely event of a plane crash, we might need to extract quickly the list of all persons on a flight. The following query does just that: select passenger.last_name as ‘last name’, passenger.first_name as ‘first name’, ‘passenger’ as ‘type’, airline.description, flight.number from reservation inner join passenger on reservation.passenger_id = passenger.id inner join flight on reservation.flight_id = flight.id inner join airline on flight.airline_id = airline.id where reservation.flight_id = 34 union select crew.last_name as ‘last name’, crew.first_name as ‘first name’, ‘crew’ as ‘type’, airline.description, flight.number from flight_crew inner join crew on flight_crew.crew_id = crew.id inner join flight on flight_crew.flight_id = flight.id inner join airline on flight.airline_id = airline.id
Note: If you are looking for best quality webspace to host and run your tomcat application check Vision shared web hosting services