AirNav Reports vs Live Radar screen

[tarbat]

How looks the query within the data for the airline-name?

Code: [Select]

SELECT DISTINCT
  v_Flights.Registration,
  v_Flights.EndTime,
  v_Flights.Callsign,
  v_Flights.Route,
  Aircraft.Airline,
  v_Flights.StartAltitude,
  v_Flights.EndAltitude,
  v_Flights.MsgCount,
  v_Flights.ModeS
FROM
 v_Flights
 LEFT OUTER JOIN Aircraft ON (v_Flights.ModeS=Aircraft.ModeS)
ORDER BY
  v_Flights.Registration,
  v_Flights.EndTime,
  v_Flights.ModeS

[frogger]

This works perfect. Thank you again!