title: Select Items that don't have matching Items in another table
body: <pre>                          Tables
   _________________________       _________________________
  |__________items__________|     |_______readStatus________|
  |___itemId___|____data____|     |___itemId___|___status___|
  | 1          | cats       |     | 1          | 1          |
  | 2          | dogs       |     | 2          | 1          |
  | 3          | fish       |     |            |            |
   -------------------------       -------------------------
  </pre>
  
  <p>I have two MySQL tables similar to like shown above. I need to get entries from the <code>item</code> table that don't have a corresponding <code>status</code> <code>1</code> in the <code>readStatus</code> table. So in this example I need the entry where <code>data</code> is <code>fish</code>. I'm not very familiar with SQL so I'm not exactly sure how to get about this but based on other questions I've come up with this:</p>
  
  <pre><code>SELECT * 
  FROM items
  INNER JOIN
  readStatus
  ON  items.itemId = readStatus.itemId
  WHERE readStatus.status != 1
  </code></pre>
  
  <p>This does not work though because it skips any entries in the <code>items</code> table that don't have a matching entry in the <code>readStatus</code> table. Adding <code>status</code> <code>0</code> entries to search for isn't an option because it would eventually create millions of entries. Also it looks like, in phpMyAdmin, it merges the entries into one output which I don't really want but it's not a dealbreaker.</p>
  
  <p>Any help is appreciated.</p>