You are viewing a single comment's thread. Return to all comments →
Select CITY.NAME FROM CITY JOIN COUNTRY ON CITY.COUNTRYCODE = COUNTRY.CODE where COUNTRY.CONTINENT = 'Africa' ORDER BY COUNTRY.NAME, CITY.NAME;
This worked for me , i kept displaying the country.name too . so i errored a lot
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 CITY.NAME FROM CITY JOIN COUNTRY ON CITY.COUNTRYCODE = COUNTRY.CODE where COUNTRY.CONTINENT = 'Africa' ORDER BY COUNTRY.NAME, CITY.NAME;
This worked for me , i kept displaying the country.name too . so i errored a lot