title: MySQL query booking system - remove entry if room is already booked
body: <p>I have been banging my head on this (im a newbie in MySQL, be patient) for two days and i cannot get around this query i want to make... First the data:</p>
  
  <p>I have two tables, one for the rooms like this:</p>
  
  <ul>
  <li>table ROOMS</li>
  <li>id_room | tipe_room | view_room</li>
  <li>1.1     | Single    | Sea</li>
  <li>1.2     | Single    | Country</li>
  <li>1.3     | Double    | Sea</li>
  <li>1.4     | Double    | Country</li>
  <li><p>1.5     | Single    | Sea</p></li>
  <li><p>table RESERVATIONS</p></li>
  <li>id_reservation | client_number | n_room | check_in   | check_out</li>
  <li>1              | 1             | 1.1    | 2012-02-20 | 2012-02-24</li>
  </ul>
  
  <p>If a person wants to book a room with <strong>tipe_room=Single</strong> and <strong>view_room=Sea</strong> and <strong>check_in date=2012-02-15</strong> and <strong>check_out date=2012-02-20</strong> i want it to return the id_room available (1.1 and 1.5).</p>
  
  <p>Now if a person wants to book a room with <strong>tipe_room=Single</strong> and <strong>view_room=Sea</strong> and <strong>check_in date=2012-02-19</strong> and <strong>check_out date=2012-02-23</strong> i want it to return the id_room available (only 1.5).</p>
  
  <p>I have been trying around JOIN conditions but when conditions are met it excludes all rooms...</p>
  
  <p>How can I do this, please?</p>
  
  <p>Best Regards, Alex</p>