Join two fieds of table 1 with different records but on table2 with same foreign key

[codeexplorer]

Hi,

I have two columns in table1 i.e. hotel1 and hotel1 . Both of them have foreign key of second table2 hotels.

i.e. Table 1 (Book)
person hotel1 hotel2
xyz 1 3

Table 2 Hotels
id Name
1 HotelName1
2 HotelName2
3 HotelName3

I want to join in such a way that I get hotel names corresponding to table1. Please guide.

[harishgg1]

does this look like something you want

[codeexplorer]

Thank you. It worked.