You are viewing a single comment's thread. Return to all comments →
MySQL
SELECT ci.NAME FROM CITY ci JOIN COUNTRY co ON ci.COUNTRYCODE = co.CODE WHERE 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 →
MySQL
SELECT ci.NAME FROM CITY ci JOIN COUNTRY co ON ci.COUNTRYCODE = co.CODE WHERE CONTINENT = 'Africa';