You are viewing a single comment's thread. Return to all comments →
select c.name from city c left join country c1 on c.countrycode = c1.code where c1.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 c.name from city c left join country c1 on c.countrycode = c1.code where c1.continent = 'africa';