AirNav RadarBox
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
 


Author Topic: AirNav Reports vs Live Radar screen  (Read 23903 times)

0 Members and 1 Guest are viewing this topic.

tarbat

  • ShipTrax Beta Testers
  • Hero Member
  • *
  • Posts: 4219
    • Radarbox at Easter Ross
Re: AirNav Reports vs Live Radar screen
« Reply #30 on: November 13, 2011, 01:22:36 PM »
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

  • New Member
  • *
  • Posts: 17
Re: AirNav Reports vs Live Radar screen
« Reply #31 on: November 13, 2011, 01:48:54 PM »
This works perfect. Thank you again!