SELECT R.RoomNo, R.RoomType, R.HotelName 
FROM Room R, RoomType RT
WHERE RT.RoomType = R.RoomType
AND RT.MaxOccup = '&Max_Occupancy'
AND R.HotelName = '&Hotel_Name'
AND R.RoomNo NOT IN
(
 SELECT RoomNo FROM Allocation
 WHERE AllocDate = '&Date'
)
/