title: SQL query to search for room availability
body: <p>The follow tables I have are: </p>
  
  <pre><code> CUSTOMERS (CustomerID, firstname, surname etc)
   ROOMS (RoomID, RoomType, Description)
   BOOKING (BookingID, CustomerID, Arrival Date, Departure Date, number of people, total cost)
   ROOMS_BOOKED (BookingID, RoomID)
  </code></pre>
  
  <p>The user enters two dates arrival and departure. Then checks for room availability. There is a room booked at the moment which I have inserted into the database myself. So the BOOKING table now includes BookingID = 1, CustomerID = 1, Arrival Date = 24/03/2015, Departure Date = 26/03/2015, number of people = 1, total cost = 40.00. Then in the ROOMS_BOOKED table I Have BookingID = 1 and RoomID = 2 which is a standard room.</p>
  
  <p>I am using this sql code - </p>
  
  <pre><code>   SELECT RoomType FROM ROOMS WHERE RoomID NOT IN (SELECT RoomID FROM ROOMS_BOOKED) 
  </code></pre>
  
  <p>This query is returning rooms that have not been booked, but is not what Im looking for. For example the user selects the same dates that are booked in the database. I therefore want to be able to display all room types on the next page and display an x or something for the particular room type that is booked on those selected dates, something similar to www.galgorm.com. </p>
  
  <p>I need help with this, everytime I post a question about this I never get an answer or some form of help. I have got so far with this hotel system with the design, I now want to be able to finish it off.</p>
  
  <p>Please help me, im sure sometimes you have been in the same situation needing help.</p>