I really hope someone can help me with this one.
It is a Hotel Booking System:
Tbl Room (RoomID, Floor, Notes)
Tbl BookingsRoom (RoomID, BookingID)
Tbl Bookings (BookingsID, StartDate, EndDate, Comments)
I have to create an SQL select statement for checking if a room is bookable during a given time period.
SELECT * FROM Room WHERE RoomID = ‘111’ AND NOT EXISTS (SELECT… now I am stuck how do I do with dates in different columns I can’t do BETWEEN or can I…