Вход на сайт
my SQL
765 просмотров
Перейти к просмотру всей ветки
в ответ melodi_ 26.05.21 13:26
create view flightexecution_arrival as
select f.flight_no, a.airport_name as von, ar.airport_name as nach, f.departure_date_time_utc as Departure,
f.flight_duration_minutes as Duration, f.departure_date_time_utc + interval f.flight_duration_minutes minute as 'Landing Time'
from flightexecution f, airport a, airport ar
where f.icao_code_origin = a.icao_code and f.icao_code_destination = ar.icao_code
having f.departure_date_time_utc + interval f.flight_duration_minutes minute > now();