title: Find value that is not equal to another value
body: <p>Hi all i'm currently doing some SQL homework and am looking for a push in the right direction.
  I need to display a list of directors that have never worked in a paramount picture movie.</p>
  
  <pre><code>select distinct directorID
  from movieinfo natural join directinfo
  where studio &lt;&gt; 'Paramount Picture';
  </code></pre>
  
  <p>This displays both directors who never have, as well as directors who have worked for paramount and also done another job with someone else.</p>
  
  <p>I thought maybe an EXISTS sub query would help me but i ended up with the exact same result.</p>
  
  <p>Would anyone know a way to check if directer EVER worked with paramount and to cross them off the list?</p>
  
  <p>EDIT**
  DirectorID does not belong in both tables.
  directinfo(mvid, directorID)
  movieinfo(mvid, title, rating, year, length, studio)</p>