SELECT
r1.PathId,
Go_Back = CASE WHEN GoDistance IS NULL THEN 'Back' ELSE 'Go' END,
CityFrom = r1.City,
CityTo = r1.City,
Distance = ISNULL(GoDistance, BackDistance)
FROM
dbo.Routes r1
INNER JOIN
dbo.Routes r2
ON
r1.PathID = r2.PathID AND
r1.City <> r2.City