title: SQL select the available rooms by date cheking
body: <p>I have in my database a table called rooms that contain the rooms information and property ,and another table called reservation table that contain the Room Reserved, FromDate and ToDate .</p>
  
  <p>What i want to do is to make the user pick room size that he want to reserve and pick the date for reserving the room ,then i provide for him the available rooms depend on the Room Reservation table.</p>
  
  <p>here what i did:</p>
  
  <pre><code>SELECT  * FROM Rooms,Reservations WHERE 
  Rooms.R_Size = 'roomSize' AND ('4/19/2013' NOT 
  BETWEEN Reservation.FromDate AND Reservation.ToDate  AND '4/19/2013'
  NOT BETWEEN Reservation.FromDate AND Reservation.ToDate) 
  </code></pre>
  
  <p>The problem its return to me duplicate's rooms and even if its between the reserved date in specific reservation but its not between reserved date in another reservation still it will return it to me.</p>
  
  <p>What i want is to check if the room is reserved at the same or between a specif date and if it is i don't want it to be selected and returned at all.</p>
  
  <p>Thanks.. and sorry for my poor english</p>