title: MySQL Show rows that exist in one table but not it another
body: <p>I have the following tables:</p>
  
  <ol>
  <li><code>organisation</code>
  <ul>
  <li><code>organisation_id</code>, <code>organisation_name</code></li>
  </ul></li>
  <li><code>srp_reseller_buffer</code>
  <ul>
  <li><code>organisation_id</code>, <code>property_id</code></li>
  </ul></li>
  </ol>
  
  <p>I want to write a MySQL query which shows me all the records in organisation except those that are in <code>srp_reseller_buffer</code> and have a <code>property_id</code> of X</p>
  
  <p>This is what I have so far:</p>
  
  <pre><code>SELECT * FROM organisation
      WHERE NOT EXISTS (
          SELECT * FROM organisation 
              LEFT OUTER JOIN srp_reseller_buffer 
                  ON srp_reseller_buffer.organisation_id = organisation.organisation_id 
              WHERE srp_reseller_buffer.property_id is NULL 
  </code></pre>
  
  <p>And that SQL query is not working. It just shows me a list of all the organisations in organisation table.</p>