title: Getting rooms that are free between two dates MySQL
body: <p>I have two tables in MySQL. First is a Room.
  and second is Reservation.
  In Table reservation i have Room_Id and Reservation_DateFrom and Reservation_DateTo
  How can i make a query that take two random dates for example (12-12-2012 and 21-12-2012) and see if the specific room is free all of the days from 12-12-2012 to 21-12-2012 if i have
  DateFrom and DateTo for rooms in Reservation. I want to list all rooms that are available for rent on these days. For example if Room 1 has reservation from 15-12-2012 to 20-12-2012 
  it will not return it because some days from 12-12-2012 to 21-12-2012 are already reserved.</p>
  
  <p>Thanks.</p>