Specify the type of join. The FROM clause joins FLIGHTS with itself and creates a table that contains every possible combination of rows (a Cartesian product). The table contains two rows for each possible route, for example, PAR <-> WAS and WAS <-> PAR .

      from flights as f1, flights as f2