You are viewing a single comment's thread. Return to all comments →
For MySQL
Select City.Name From City Inner Join Country on City.CountryCode = Country.Code Where Continent = 'Africa';
In below we used 'where' instead of using join to give condution so they will connect like it did when we used 'Inner Join'
Select City.Name From City, Country Where Country.Code = City.CountryCode And Continent = 'Africa';
Seems like cookies are disabled on this browser, please enable them to open this website
African Cities
You are viewing a single comment's thread. Return to all comments →
For MySQL
In below we used 'where' instead of using join to give condution so they will connect like it did when we used 'Inner Join'