All pastes #340735 Raw Edit

Anonymous

public text v1 · immutable
·published 2007-02-04 23:55 UTC
rendered paste body
SELECT RoomNum
FROM Room
WHERE NOT EXISTS(SELECT 1 FROM Booking,BookingDetails,Room 
		WHERE BookingDetails.RoomNum = Room.RoomNum AND CURRENT_DATE BETWEEN Booking.ArrivalDate AND Booking.DepartDate);