SELECT f.name country, c.name city FROM cities c INNER JOIN facts f ON c.facts_id = f.id
Why does the output of the above INNER JOIN maintain the order of
cities and not
In other words, the INNER JOIN looks first at
cities , then finds the corresponding
facts and performs the join. Why not the other way around?