African Cities | Editorial by aksingh007
All EditorialsThe problem can be solved using INNER JOIN as follows:
```
SELECT CITY.NAME FROM CITY
INNER JOIN COUNTRY ON
CITY.COUNTRYCODE=COUNTRY.CODE
WHERE COUNTRY.CONTINENT='AFRICA';
```
The problem can be solved using INNER JOIN as follows:
SELECT CITY.NAME FROM CITY
INNER JOIN COUNTRY ON
CITY.COUNTRYCODE=COUNTRY.CODE
WHERE COUNTRY.CONTINENT='AFRICA';