title: MySQL query on single table to find multiple rows
body: <p>I am trying to figure out a way to find shared credits by two people in a movie database, for example:</p>
  
  <p>table: 'credits'<br>
  columns: 'id','movie','person'<br></p>
  
  <p>My other problem is a person might have multiple credits for the same movie, so how do I filter out duplicates? Any help would be appreciated. The following is what I have so far. Am I on the right track?</p>
  
  <pre><code>SELECT DISTINCT movie
  FROM credits
  WHERE person = 'condition1' OR person = 'condition2'
  GROUP BY movie
  HAVING COUNT(*)=2
  </code></pre>