Skip to content

Instantly share code, notes, and snippets.

@nickfox

nickfox/gist:1322519

Created October 28, 2011 15:19
Show Gist options
  • Save nickfox/1322519 to your computer and use it in GitHub Desktop.
Save nickfox/1322519 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
SELECT a1.airportDescription toAirport, a2.airportDescription fromAirport, c.classDescription class, a.airlineDescription airline
FROM allowances al
JOIN airports a1 ON a1.airportID = al.toAirportID
JOIN airports a2 ON a2.airportID = al.fromAirportID
JOIN class c ON c.classID = al.classID
JOIN airlines a ON a.airlineID = al.airlineID;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment