mysql - 'LEFT JOIN' 附近的错误 1064

Question

我创建了两个临时表并使用以下代码将它们连接在一起，但在“LEFT JOIN”附近遇到了 ERROR 1064。

(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;

想要的结果是这样的:

route_short_name, first_stop_name, last_stop_name
...

Answer 1

您没有错过实际的主要选择语句吗？

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;