I have two tables, Flats (FlatID, Court_No, Flat_No, Description) and Bookings (BookingID, FlatID, CheckInDate, CheckOutDate). The Flats table contain 19 flats that a company has and the Bookings table stores the bookings for a customer. What I would like to do is to devise a query that will return all the available flats. For example, I have a booking for 16/03/2003-20/03/2003 for Flat1. If I search for an available apartment between any of these dates, it should not return this flat (From a form that will have 2 input boxes for Check In Date and Check Out Date).
Can anyone help me please because I am really stuck.
Thanks
Can anyone help me please because I am really stuck.
Thanks