How can I fetch all possible flights between two cities?

Question

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

Expected results:

not with same city.

have you able to fetch all records form database? if yes then show your code... — er.irfankhan11, Jun 12 '17 at 05:39

Haseeb A · Accepted Answer · 2017-06-12T06:13:20.020

1

try this,

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

edited Jun 12 '17 at 06:13

answered Jun 12 '17 at 05:41

Haseeb A

Thank you! it works.. But we are considering same table, twice. It won't affect performance ? – harish_sng Jun 12 '17 at 05:45

1 Answers1