Beginner SQL question

[King Kong]

Dear all,
I am a real new beginner and hence, can't solve certain questions arising to me in the task to learn more.
I have a table with the following structure
id---Name---Country_ID---First1_ID---First2_ID---First3_ID....
Example
1---Smith---1---3---1---4---2
2---Haydn---3---2---4---5---1
So besides id and name, all other field contents are referring to another table which looks like this
id---Firstname---Country_ID---XXX---YYY
Example
1---Peter---3---Content---House
2---Michael---1---Content---House
3---Clive---2---Content---House
4---XXX
5---YYY
etc.
I would want to have a view which shows the first table but without the IDs with the real content.
Example:
1---Smith---1---Clive---Peter---XXX---Michael
2---Hayd---3---Michael---XXX---YYY---Peter

I just can't get it done.
Can someone help me? I would need this kind of logic elsewhere hence to understand the rationale behind this would be very very helpful in my learning (by example and doing but slowly).
Thanks in advance
Herbert