title: Selecting rows from one table using values gotten from another table MYSQL
body: <p>I have currently have 2 mysql tables in my db </p>
  
  <p><code>Film</code> and <code>Film_Ratings_Report</code> </p>
  
  <p>The primary key for Film is <code>filmid</code> which is used to identify the film ratings in the <code>Film_Ratings_Report</code> table. </p>
  
  <p>I would like to know if its possible using a MYSQL query only to search the ratings table and collect all film ids which fit a certain criteria then use the selected IDs to get the film titles from the Film table. Below is the MYSQL query Im using which isnt working:</p>
  
  <pre><code>SELECT * 
  FROM film 
  UNION SELECT filmid 
        FROM film_rating_report 
        WHERE rating = 'GE' 
        LIMIT 0,0
  </code></pre>
  
  <p>I am relatively green to MYSQL and would appreciate any help on this.</p>
  
  <p>Thanks in Advance</p>