title: I'm trying to use the MySQL NOT IN command, but to no avail, could anyone point out the error in my syntax?
body: <pre><code>(SELECT s
  FROM enrolls
  WHERE s)
  NOT IN
  (SELECT s
  FROM likes
  WHERE s);
  </code></pre>
  
  <p>I've got two tables, <code>enrolls</code> and <code>likes</code>, and I'm trying to find s from enrolls where all of the tuples of s <code>likes</code> and <code>enrolls</code> have in common are removed (or <code>enrolls - likes</code>, basically).</p>
  
  <p>I get the following error, though:</p>
  
  <blockquote>
    <p>You have an error in your SQL syntax; check the manual that
    corresponds to your MySQL server version for the right syntax to use
    near 'NOT IN (SELECT s FROM likes WHERE s)' at line 4</p>
  </blockquote>