road.sql

create table town(id, label);

create table road(id, start_town_id, end_town_id);

create table travel(id, road_id);

-- I want all town, both start and end
select 
unnest(array[start_town_id, end_town_id])
from travel
inner join road on road_id = road.id