how to join multiple table in mysql
SELECT CI.NAME FROM COUNTRY CO JOIN CITY CI ON CI.CountryCode = CO.CODE WHERE CO.CONTINENT = 'Africa';
SELECT CI.NAME FROM COUNTRY CO JOIN CITY CI ON CI.CountryCode = CO.CODE WHERE CO.CONTINENT = 'Africa';