I have an order file that has origin_city & destination_city fileds. Both are codes that reference records in the city file. I am trying to create a query that will select the city_name for both of the city codes.

I have tried left Outer Join of the Order File to the City file on the origin_city = city_code and a separate join for the destination_city. I’m only able to get the first city_name to come back from the city_file.