title: MySQL 'WHERE' clause which excludes results in subquery
body: <p>I have the following SQL query:</p>
  
  <pre><code>SELECT members.member_ID, members.nick_name 
            FROM orgs
      INNER JOIN assets ON assets.org_ID = orgs.org_ID
      INNER JOIN orgs_to_members ON orgs_to_members.org_ID = orgs.org_ID
      INNER JOIN members ON members.member_ID = orgs_to_members.member_ID
      where orgs.org_ID = '7' 
      AND NOT EXISTS (select shares.member_ID from shares where shares.asset_ID = '224')
  </code></pre>
  
  <p>There are 3 members in org 7:</p>
  
  <pre><code>     - member_ID 1
       - member_ID 4
       - member_ID 6
  </code></pre>
  
  <p>In the subquery, member IDs 1 and 4 result. I am trying to write 1 query which will return only member ID #6. When i run the above query, I get no results. When I separate them, I get the expected results. Please help.</p>
  
  <p>Thanks!</p>