title: mysql results if no records in join table
body: <p>I looked en searched but could not find an answer.
  I need to see the records in houses_houses if there are no matching records in houses_availability.
  I know it has something to do with IS NULL but all I tryed failed.
  Please help.</p>
  
  <pre><code>SELECT 
      houses_houses.*, 
      houses_availability.from_date 
  FROM 
      houses_houses 
  LEFT JOIN 
      houses_availability ON houses_houses.sid=houses_availability.housesid 
  WHERE 
      houses_availability.from_date&gt;='2015-09-05' 
  AND 
      houses_availability.until_date&lt;'2015-09-11'  
  ORDER BY houses_houses.sid LIMIT 0, 9
  </code></pre>