We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
  1. Prepare
  2. SQL
  3. Basic Join
  4. African Cities
  5. Discussions

African Cities

  • ashish98875
     + 1 comment

    Works in MySql:

    select city.name from city, country 
where city.countrycode = country.code 
and country.continent='africa';

    or,

    select city.name from city inner join country 
on city.countrycode = country.code 
where country.continent='africa';