title: Why does MySQL report a syntax error on FULL OUTER JOIN?
body: <pre><code>SELECT airline, airports.icao_code, continent, country, province, city, website 
  
  FROM airlines 
  FULL OUTER JOIN airports ON airlines.iaco_code = airports.iaco_code
  FULL OUTER JOIN cities ON airports.city_id = cities.city_id
  FULL OUTER JOIN provinces ON cities.province_id = provinces.province_id
  FULL OUTER JOIN countries ON cities.country_id = countries.country_id
  FULL OUTER JOIN continents ON countries.continent_id = continents.continent_id
  </code></pre>
  
  <p>It says that </p>
  
  <blockquote>
    <p>You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'outer join <code>airports</code> on airlines.iaco_code = airports.iaco_code
    full outer join' at line 4</p>
  </blockquote>
  
  <p>The syntax looks right to me. I've never done a lot of joins before, but I need those columns in a table which is cross referenced by various id's.</p>