Code Snippet:
1 USE world;
2 SELECT ci.name AS "City Name",
3 co.name AS "Country Name",
4 cl.language AS "Country Language"
5 FROM city ci
6 JOIN country co
7 ON ci.CountryCode = co.Code
8 JOIN country language cl
9 ON cl.CountryCode = ci.CountryCode;
Results:
JOIN countrylanguage cl.
ON cl.CountryCode = ci.CountryCode;
This content is provided to you freely by BYU-I Books.
Access it online or download it at https://books.byui.edu/learning_mysql/joining_more_than_tw.