title: how to query many-to-many?
body: <p>I found the following table structures while I was watching ruby on rails tutorial.</p>
  
  <pre><code>table actors
  id  int  11  primary key auto_increment
  name  varchar  30
  
  table movies
  id  int  11  primary key auto_increment
  name  varchar  30
  
  table actors_movies
  actor_id  int  11
  movie_id  int  11
  </code></pre>
  
  <p>How do I make a query to select movies that an actor is involved in?</p>
  
  <p>I am not asking for ruby on rails code. I want the actual mysql query string.</p>
  
  <p>Thank you!</p>