You can use a JOIN to get results from two or more related tables.
In this example each row of the table
games is related to
a row of the table
If you want to find the country where the games took place
you must JOIN the games table to the city table on the
common field that is games.city and city.name