I have three tables; table 1 is called 'neighbours' and consists of 2 columns, both representing the country's id:
c1 c2
1 2
1 3
1 4
1 5
2 4
2 5
2 6
2 10
3 5
4 5
5 7
5 12
6 12
8 9
10 11
13 14
The 2nd table consists of several columns a.o.: country_id/name of country/capital_id
And the 3rd table consisits of the columns: capital_id/name of capital/country_id
What I need to do is to list all the "neighbour" country's of country nr5 alphabetically with their capitals.
How can I make this happen?? If you want more information about the tables, please tell.
Thanks, stef123
c1 c2
1 2
1 3
1 4
1 5
2 4
2 5
2 6
2 10
3 5
4 5
5 7
5 12
6 12
8 9
10 11
13 14
The 2nd table consists of several columns a.o.: country_id/name of country/capital_id
And the 3rd table consisits of the columns: capital_id/name of capital/country_id
What I need to do is to list all the "neighbour" country's of country nr5 alphabetically with their capitals.
How can I make this happen?? If you want more information about the tables, please tell.
Thanks, stef123
