Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
SELECT t.TripId_PK, ls.name StartLocationName, le.name EndLocationName
FROM trips t
JOIN locations ls
ON ls.LocationId_PK = t.StartLocationId_FK
JOIN locations le
ON le.LocationId_PK = t.EndLocationId_FK