-
Poblem h foreign key
Hi
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
please
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|