We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
- Prepare
- SQL
- Basic Join
- African Cities
- Discussions
African Cities
African Cities
Sort by
recency
|
902 Discussions
|
Please Login in order to post a comment
SELECT CITY.NAME FROM CITY INNER JOIN COUNTRY ON CITY.COUNTRYCODE = COUNTRY.CODE WHERE COUNTRY.CONTINENT = 'AFRICA';
select city.name from city inner join country on city.countrycode = country.code where continent = "africa";
Using MySQL:
MY SQL SELECT C1.NAME FROM CITY C1 INNER JOIN COUNTRY C2 ON C1.COUNTRYCODE = C2.CODE WHERE C2.CONTINENT = 'Africa';
SELECT CITY.NAME FROM CITY JOIN COUNTRY ON CITY.CountryCode = COUNTRY.CODE WHERE CONTINENT = 'Africa' ;
FOR ORACLE