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