多外键的mysql查询

zysjyyx4 于 2021-06-20 发布在 Mysql

关注(0)|答案(1)|浏览(175)

mysql表如下

+------------+----------------+----------------+
    | booking_id | boarding_point | dropping_point |
    +------------+----------------+----------------+
    |          1 |              2 |              4 |
    |          2 |              1 |              2 |
    +------------+----------------+----------------+

+-------------+---------------+
    | location_id | location_name |
    +-------------+---------------+
    |           1 | chennai       |
    |           2 | coimbatore    |
    |           3 | tiruppur      |
    |           4 | erode         |
    |           5 | salem         |
    +-------------+---------------+

登机点和降落点是位置id的外键。现在我希望select查询显示如下

+------------+----------------+----------------+
    | booking_id | boarding_point | dropping_point |
    +------------+----------------+----------------+
    |          1 |     coimbatore |          erode |
    |          2 |        chennai |     coimbatore |
    +------------+----------------+----------------+

任何人都可以建议我的查询显示如上所述。

mysql Database rdbms

来源：https://stackoverflow.com/questions/52148135/mysql-query-for-multiple-foreign-keys

1条答案

按热度按时间

yhived7q1#

将预订表连接到位置表两次：

SELECT
    b.booking_id,
    t1.location_name,
    t2.location_name
FROM booking b
INNER JOIN location t1
    ON b.boarding_point = t1.location_id
INNER JOIN location t2
    ON b.dropping_point = t2.location_id;

演示

赞(0）回复(0）举报 2021-06-20

我来回答

多外键的mysql查询

1条答案

演示

相关问题

热门标签

最新问答