select a.company, a.num, c.name, d.name

from route a join route b on (a.company, a.num) = (b.company, b.num)

join stops c on (a.stop = c.id)

join stops d on (b.stop = d.id)

where c.name = 'Craiglockhart' and d.name = 'London Road'