African Cities

Sort by

recency

|

1054 Discussions

|

  • + 0 comments
    SELECT CITY.NAME FROM CITY JOIN COUNTRY ON CITY.COUNTRYCODE=COUNTRY.CODE WHERE CONTINENT='Africa';
    
  • + 0 comments

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

  • + 0 comments

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

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