title: discard SQL result based on the value of another table
body: <p>I'm very lost when it comes to nested sql statements.</p>
  <p>I'm currently building a database to manage executive suites and I'd like to be able to find vacant suites by comparing what I have leased vs the total suites I have available.</p>
  <p>This is the best I've been able to come up with:</p>
  <pre><code>SELECT * FROM `executiveSuites` 
  LEFT JOIN `executiveLease` 
  ON executiveLease.suiteNumber = executiveSuites.SuiteNumber 
  AND executiveLease.Property = executiveSuites.BuildingID 
  WHERE NOT EXISTS 
  ( SELECT * FROM `executiveLease` WHERE executiveLease.status = 1 )  
  </code></pre>
  <p>the expected result would be that any suite that doesn't have a lease attached with a status of 1 would show up but what I'm getting is a blank list.</p>
  <p>I'm self taught and don't know what I don't know, so any help or at the least a point in the right direction is very much appreciated.</p>