title: How to query many to many that might not exist?
body: <p>Say I have these tables and values</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 would I query the database to get all actors and movies they are in?</p>
  
  <p>For example, something like this:</p>
  
  <p>Select actors.name, movies.name from ......(QUERY)....</p>
  
  <p>And the output would be something like this</p>
  
  <pre><code>actors.name movies.name movies.name movies.name
  Bob         Movie A     NULL        NULL
  Melissa     Movie A     Movie B     NULL
  Rick        NULL        NULL        Movie C
  </code></pre>