ERROR 1064 near 'LEFT JOIN'

Question

I create two temporary tables and join them together using the following codes but encounter ERROR 1064 near 'LEFT JOIN'.

(SELECT DISTINCT routes.route_short_name, MIN(stop_times.stop_sequence) AS first_stop, stops.stop_name AS first_stop_name
FROM trips
JOIN routes ON ...
JOIN stop_times ON ...
JOIN stops ON ...
JOIN calendar ON ...
GROUP BY stop_times.trip_id) first_table
LEFT JOIN
(SELECT DISTINCT routes.route_short_name, MAX(stop_times.stop_sequence) AS last_stop, stops.stop_name AS last_stop_name
FROM trips
JOIN routes ON ...
JOIN stop_times ON ...
JOIN stops ON ...
JOIN calendar ON ...
GROUP BY stop_times.trip_id) last_table
ON first_table.route_short_name = last_table.route_short_name;

The desired results are something like:

route_short_name, first_stop_name, last_stop_name
...

Answer 1

Aren't you missing the actual main select statement?

SELECT route_short_name, first_stop_name, last_stop_name FROM   --this part is missing
(SELECT DISTINCT ...) first_table
LEFT JOIN
(SELECT DISTINCT ...) last_table
ON first_table.route_short_name = last_table.route_short_name;