title: Joining two tables and then selecting only info based on criteria in a third table
body: <p>So I joined two tables but I only want to select info from that join based on criteria defined in another table. I only want info from the first join where the actors name is in the popactor table. </p>
  
  <pre><code>select  h.movie,
          h.released,
          a.rating,
          h.actor
    from  hollywood.stars h
      inner join starmovies a on h.movie =a.title
      inner join popactor p on p.actor = h.actor
    where h.movie = a.title and p.actor = h.actor;
  </code></pre>