Advise in Linking same table 2 id columns with another table one id column

[Prathap1]

Hi All,

Little bit confused in a relationship I do need to link table 1 and table 2. Thanks in advance

Table1 ID with Table2 ID

Table2 RelatedID with table1ID

Table1:

ID   Country       XXXX
1    UK                kwf
2    USA            gywy
3    INDIA          gwe

Table2:

ID       RelatedID
1
2         1(Country value is UK)
3

Might be a bad example ..  please assist 

Thanks,

Prathap

[parry2k]

@Prathap1 what you are trying to achieve? Your goal is not clear.