African Cities

Sort by

recency

|

1051 Discussions

|

  • + 0 comments

    select distinct a.NAME from CITY as a LEFT JOIN COUNTRY as b on a.COUNTRYCODE = b.CODE where b.CONTINENT = 'Africa';

  • + 0 comments

    SELECT C.NAME FROM CITY C LEFT JOIN COUNTRY O ON C.COUNTRYCODE=O.CODE WHERE O.CONTINENT='Africa';

  • + 0 comments
    select
        ct.name
    from 
        city ct 
        left join country cntry 
            on ct.countrycode = cntry.code
    where cntry.continent = 'Africa'
    
  • + 0 comments

    For MySQL Platform

    SELECT city.name FROM city
    JOIN country ON city.countrycode = country.code
    WHERE country.continent = "africa";
    
  • + 0 comments

    MYSQL SELECT CITY.NAME FROM CITY JOIN COUNTRY ON CITY.CountryCode = COUNTRY.Code WHERE CONTINENT = 'Africa';