title: Compound SQL SELECT
body: <p>I have the following two tables:</p>
  
  <p>auth_user</p>
  
  <ul>
  <li>id</li>
  <li>username</li>
  <li>is_active (boolean)
  ...</li>
  </ul>
  
  <p>useprofile_userprofile</p>
  
  <ul>
  <li>id</li>
  <li>user_id
  ...</li>
  </ul>
  
  <p>How would I find all <code>auth_user</code> objects where <code>is_active</code>=0 and there is no userprofile_userprofile object with that <code>user_id</code>? For example, an entry like this --</p>
  
  <p>auth_user</p>
  
  <ul>
  <li>id = 1</li>
  <li>username = hello@gmail.com</li>
  <li>is_active = 0</li>
  </ul>
  
  <p>and <code>userprofile_userprofile</code> has no object where <code>user_id</code> = 1</p>