You are viewing a single comment's thread. Return to all comments →
select distinct a.NAME from CITY as a LEFT JOIN COUNTRY as b on a.COUNTRYCODE = b.CODE where b.CONTINENT = 'Africa';
Seems like cookies are disabled on this browser, please enable them to open this website
African Cities
You are viewing a single comment's thread. Return to all comments →
select distinct a.NAME from CITY as a LEFT JOIN COUNTRY as b on a.COUNTRYCODE = b.CODE where b.CONTINENT = 'Africa';