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