I have two columns: tblPerson and rCou
in rCou, countries have an id, and they have readable names
example: id 20 ='Belgium'
In my tblPerson I have two fields (among others) that hold country related data.
One is the country of birth, the other is nationality.
Suppose my person is born in country 20 , but has the country 30 nationality.
tblPerson Inner Join
rCou On rCou.CouKey = tblPerson .PerCouBirth
This gives me the record with the two countrycodes, and the readable name for the PerCouBirth code.
But I also need the readable name for the PerCouNationality code.
How do I do that?