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


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.

does this look like something you want

1 Like

Thank you. It worked.