New to databasing in general. Is it possible to do this?
I've built the tables but no idea how to do the Query.
Table 1:
Code:
ID | Country |
-------------------------------------------------
1 UK
2 CANADA
Table 2:
Code:
ID | Table1.ID | City | Priority
--------------------------------------------
1 1 London 1
2 1 Dover 2
3 1 Brighton 3
4 2 Vancouver 1
Query Result:
Code:
Country | City1 | City2 | City3 |
UK London Dover Brighton
If anyone has any suggestions, it would be much appreciated.
Thanks