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
|
898 Discussions
|
Please Login in order to post a comment
SELECT CITY.NAME FROM CITY JOIN COUNTRY ON CITY.CountryCode = COUNTRY.CODE WHERE CONTINENT = 'Africa' ;
FOR ORACLE
Select ct.name from city ct inner join country c on ct.countrycode=c.code where c.continent='Africa'
SELECT CITY.NAME FROM CITY JOIN COUNTRY ON CITY.COUNTRYCODE=COUNTRY.CODE WHERE COUNTRY.CONTINENT='Africa';
SQL SERVER
SELECT CITY.NAME FROM CITY inner join COUNTRY C ON C.CODE = CITY.CountryCode WHERE C.continent = 'Africa'
`
select ci.name from city ci inner join country co on ci.countrycode = co.code where co.continent = 'Africa'