I have two tables, one Students and one Location. Location holds the City and Country, these two are connected with two foreign keys, the first is from the Location tuple in the Students table to the ID in the Location table and the second goes from the primary key in Students to the primary key in Location.

My problem is that I wnt to get all the Countries from the Location table but I want to assume from the Students table

another problem is that I want to update a students country to another country

i need sql-questions fro this