Inserting Sample Values We use the sample values (Florida web design)
Inserting Sample Values We use the sample values described in the above list of tables. Please refer to this book’s support site.. .(http://www.packtpub.com/support) for the code download which contains the tables’ definition and sample values. Boarding Pass A passenger can print his or her boarding pass while at home by using the website’s quick reference for his or her reservation, which is KARTYU in our example. Here is the generated query to retrieve the boarding pass information: select passenger.last_name, passenger.first_name, flight.number, airline.description, flight.departure_moment, flight.departure_gate, flight.boarding_moment, reservation.seat, plane_section.description 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 inner join plane_section on (airline.id = plane_section.airline_id and reservation.section_id = plane_section.id) where reservation.web_site_quick_reference = ‘KARTYU’ Executing this query retrieves these results: Passenger List Here, the airline wants a list of passengers for a specific flight; we use flight_id,. which is the primary key of the flight table, and not the flight ……………number……… because flight numbers are not unique. select reservation.seat, passenger.last_name, passenger.first_name,