CODE EXAMPLE FOR SQL

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';