African Cities

Sort by

recency

|

1048 Discussions

|

  • + 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';

  • + 0 comments

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

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

    MS SQL Server

    SELECT city.name from city INNER JOIN country ON CITY.CountryCode = COUNTRY.Code WHERE continent = 'Africa'