MySql 当 table.column = table.column 时选择 table.column

Question

假设我的数据库中有一张地铁 map ，其中每条线路的每个站点都是一行。如果我想知道我的线路在哪里互连:

mysql> SELECT LineA.stop_id FROM LineA, LineB WHERE LineA.stop_id = LineB.stop_id;
    +---------+
    | stop_id |
    +---------+
    | 1100    |
    | 1300    |
    +---------+

如何将此结果加入我的站点表以便检索站点名称？

这里是表格:

        stations
+----------------+---------+
| name           | stop_id |
+----------------+---------+
| Nation         | 1100    |
| Republic       | 1300    |
| Main_st        | 1065    |
| Airport        | 1204    |
+----------------+---------+

         LineA
+----------------+---------+
| id             | stop_id |
+----------------+---------+
| 1              | 1100    |
| 2              | 1300    |
| 3              | 1204    |
+----------------+---------+

         LineB
+----------------+---------+
| id             | stop_id |
+----------------+---------+
| 1              | 1100    |
| 2              | 1300    |
| 3              | 1265    |
+----------------+---------+

Answer 1

你离答案很近了:试试这个

select B.* from (SELECT LineA.stop_id FROM LineA, LineB WHERE LineA.stop_id = LineB.stop_id) as A
INNER JOIN stations as B on A.stop_id=B.stop_id