如何获取两个城市之间的所有可能航班？(How can I fetch all possible flights between two cities? [duplicate])

如何获取两个城市之间的所有可能航班？(How can I fetch all possible flights between two cities? [duplicate])

这个问题在这里已有答案：

如何从MySQL表中获取所有数据组合？ 3个答案

我有一个名为航班详情的MySQL表，如下所示：

预期成绩：

班加罗尔到金奈 班加罗尔到德里 班加罗尔到加尔各答 班加罗尔到孟买 钦奈到班加罗尔 钦奈到德里 钦奈到加尔各答 钦奈到孟买 德里到金奈 德里到班加罗尔 德里到加尔各答 德里到孟买 加尔各答到金奈 加尔各答飞往德里 加尔各答飞往班加罗尔 加尔各答飞往孟买 孟买到金奈 孟买到德里 孟买到加尔各答 孟买飞往班加罗尔

不是同一个城市。

This question already has an answer here:

How do I get all combinations of data from a MySQL table? 3 answers

I have a MySQL table called flight details as shown below:

Expected results:

Bangalore to Chennai Bangalore to Delhi Bangalore to Kolkata Bangalore to Mumbai Chennai to Bangalore Chennai to Delhi Chennai to Kolkata Chennai to Mumbai Delhi to Chennai Delhi to Bangalore Delhi to Kolkata Delhi to Mumbai Kolkata to Chennai Kolkata to Delhi Kolkata to Bangalore Kolkata to Mumbai Mumbai to Chennai Mumbai to Delhi Mumbai to Kolkata Mumbai to Bangalore

not with same city.

最满意答案

尝试这个，

SELECT fl1.flight_city,fl2.flight_city FROM `flight_details` as fl1 JOIN `flight_details` as fl2 on fl2.fid != fl1.fid

try this,

SELECT fl1.flight_city,fl2.flight_city FROM `flight_details` as fl1 JOIN `flight_details` as fl2 on fl2.fid != fl1.fid