How to select two rows from a joined table

So i have two tables with information below one which is a holiday table which marks the location to and from and etc. and another table that has the information on the locations

holiday_id location_from location_to start_time end_time
1 21 43 13:00 17:00
Location_id location_name
21 sydney
43 gold coast

I’d like to have an sql query which will return the names of the location to and from but because location name is under one column im not sure how to do it. any help is appreciated

>Solution :

You can join with the table, twice, using an alias:

select location_1.location_name, location_2.location_name, other, columns
from holidays
join locations location_1 on holidays.location_from = location_1.location_id
join locations location_2 on holidays.location_to   = location_2.location_id

Leave a Reply