African Cities

Sort by

recency

|

994 Discussions

|

  • + 0 comments

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

  • + 0 comments

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

  • + 0 comments
    SELECT
        CITY.NAME
    FROM 
        CITY
    INNER JOIN
        COUNTRY
    ON 
        CITY.CountryCode = COUNTRY.Code
    WHERE
        COUNTRY.CONTINENT = 'Africa';
    
  • + 0 comments

    SELECT CI.NAME FROM CITY AS CI JOIN COUNTRY AS CO ON CI.CountryCode = CO.Code WHERE CO.CONTINENT = "Africa";

  • + 0 comments

    mysql: select c.name from city c left join country co on c.countrycode = co.code where co.continent = 'Africa';