This is a new guy question , I hope it is easily answered
I would like to dereference two numbered columns to their corresponding text from a look up table in a sql statement, using a join or something like it.
dep.location as departure,
dest.location as destination
FROM flightpath fp
JOIN paths dep ON fp.departure = dep.path_no
JOIN paths dest ON fp.destination = dest.path_no
WHERE fp.flight_no = 5