Sounds like two joins. Once on hotel1 to the table2 id, then on hotel2 to table2 id. This is psuedo code, but you get the idea;

SELECT...

Because there will be two hotels that need to be allocated one for 15 days and another one for 15 days 🙂

• This reply was modified 1 year, 10 months ago by  codeexplorer1.