title: SQL query to find rows with at least one of the specified values
body: <p>Suppose you had two tables.  One called MOVIES:</p>
  
  <ul>
  <li>MovieId</li>
  <li>MovieName</li>
  </ul>
  
  <p>Then another called ACTORS that contains people who appear in those movies:</p>
  
  <ul>
  <li>MovieId</li>
  <li>ActorName</li>
  </ul>
  
  <p>Now, I want to write a query that returns any movie that contains ONE OR MORE of the following actors: "Tom Hanks", "Russell Crowe" or "Arnold Schwarzenegger".</p>
  
  <p>One way to do it would be something like:</p>
  
  <pre><code>SELECT DISTINCT A.MovieId, M.MovieName FROM ACTORS A
  INNER JOIN MOVIES M USING (MovieId)
  WHERE A.ActorName IN ('Tom Hanks', 'Russell Crowe', 'Arnold Schwarzenegger');
  </code></pre>
  
  <p>Which is perfectly fine, however in my case I might have several more of these conditions on the WHERE clause so I want to find a way to make the MOVIES table the primary table I select from.</p>
  
  <p>What's the best way to query for this?  I'm using Oracle 11g if that matters, but I'm hoping for a standard SQL method.</p>