African Cities

Sort by

recency

|

1034 Discussions

|

  • + 0 comments

    SELECT CITY.Name FROM CITY JOIN COUNTRY ON CITY.CountryCode = COUNTRY.Code WHERE COUNTRY.Continent = 'Africa';

  • + 0 comments

    WHY CAN'T LEFT JOIN BE USED , INSTEAD OF JOIN

  • + 0 comments

    MySQL

    SELECT ci.NAME FROM CITY ci JOIN COUNTRY co ON ci.COUNTRYCODE = co.CODE WHERE CONTINENT = 'Africa';

  • + 0 comments

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

  • + 0 comments

    Select CITY.NAME FROM CITY JOIN COUNTRY ON CITY.COUNTRYCODE = COUNTRY.CODE where COUNTRY.CONTINENT = 'Africa' ORDER BY COUNTRY.NAME, CITY.NAME;

    This worked for me , i kept displaying the country.name too . so i errored a lot