title: MySQL Select Combined Unique
body: <pre><code>Table: Contacts
  id    | name  | has_this
  ------------------------
  1     | Jeff  | 0
  2     | Terry | 1
  3     | Tom   | 0
  4     | Henry | 1
  
  Table: has_thing
  id    | owner | thing
  ---------------------
  1     | Terry | stuff
  2     | Tom   | stuff
  3     | Toby  | stuff
  </code></pre>
  
  <p>I want a SELECT that will return</p>
  
  <pre><code>name  | thing
  -------------
  Terry | stuff
  Tom   | stuff
  Henry | 
  Toby  | stuff
  </code></pre>
  
  <p>Basically, I think I want a JOIN but I want any name that is in table 2(has_thing) that is not in table 1 to be included the output and any name that is in table 1(Contacts) WHERE has_this=1 to be included in the output</p>