title: mySQL 'where name NOT IN' not working?
body: <p>I have this statement:</p>
  
  <pre><code>SELECT id, name 
  FROM players
  WHERE this = 1 
    AND name NOT IN (SELECT name 
                     FROM players_online 
                     WHERE this = 'that')
  ORDER BY RAND() 
  LIMIT 3, 6
  </code></pre>
  
  <p>All columns are correctly named. No SQL errors occur, it just returns no results.</p>
  
  <p>From what I've read in documentation it should work, but doesn't.</p>
  
  <p>Any idea?</p>