Search code examples
sqlsubquerycorrelated-subquery

How to merge these queries into 1 using subquery

 Select * from HotelPerson 
 Where RoomID IN (select ID from HotelRoom Where BookingID = 36 )

 Select * from HotelCancelationPolicy 
 Where RoomID IN (select ID from HotelRoom Where BookingID = 36 )

How can I merge these both queries into 1 query ?

Solution

  • This will give you all the columns from both tables in one table.

    SELECT * 
FROM HotelPerson A, HotelCancelationPolicy B
WHERE A.RoomID = B.RoomID
AND A.RoomID IN (SELECT ID FROM HotelRoom WHERE BookingID = 36)