I have created a hotel booking system programme. However, I am puzzled as to how when the booking button is clicked it can search a database and find the best suited room (RoomType) and make sure that it is available (Date of Departure < system.date).
This data is held in two tables (Access):
BookingID (Primary Key)
CustomerID (Foreign Key, Table:Customer)
Date of Arrival (Date)
Date of Departure (Date)
RoomID (Foreign Key,Table:Room)
Take a look at LIMIT to specify that you only want a single row returned. Something like: LIMIT 0,1. Also, I would move "AND Booking.[Date of Departure] < Now()" into the ON clause just for clarity sake.