You are viewing a single comment's thread. Return to all comments →
SELECT CITY.NAME FROM CITY INNER JOIN COUNTRY ON CITY.COUNTRYCODE=COUNTRY.CODE WHERE COUNTRY.CONTINENT="AFRICA";
SELECT CITY.NAME FROM CITY,COUNTRY WHERE CITY.COUNTRYCODE=COUNTRY.CODE AND COUNTRY.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 →
INNER JOIN METHOD
SELECT CITY.NAME FROM CITY INNER JOIN COUNTRY ON CITY.COUNTRYCODE=COUNTRY.CODE WHERE COUNTRY.CONTINENT="AFRICA";
WITHOUT INNER JOIN METHOD
SELECT CITY.NAME FROM CITY,COUNTRY WHERE CITY.COUNTRYCODE=COUNTRY.CODE AND COUNTRY.CONTINENT="AFRICA";