title: SQL Join with not like
body: <p>I'm on MySQL 5.0.</p>
  
  <p>I basically have a List Item table and a List Title table.  For each Title, there can be 60+ items, which are all text.  Dynamically I am trying to get Titles returned that have items people want to include or exclude.  My Query is basically:</p>
  
  <pre><code>Select Distinct TitleID from Titles
  left join Items on Items.titleID = Titles.titleID
  Where Items.Name not like 'Item 2'
  </code></pre>
  
  <p>If any Items have Name like 'Item 2' then I don't want the <code>TitleID</code>.  However there could be 59 other Names associated with a Title, so this query is still returning Every possible <code>TitleID</code>.</p>
  
  <p>How can I write it so that I only get the <code>TitleID</code>s I'm looking for?</p>