title: Select all in table where a column in table 1 exists in another table and a second column equals a variable in second table
body: <p>I know the title is confusing but its the best I could explain it. Basically im developing a cinema listings website for a company which owns two cinemas. So I have a database which has the two tables "Films" and "Listings" with data for both cinemas in them. </p>
  
  <p>I'm trying to select all films and their data for one cinema if the films name shows up in the listings (since the two cinemas share all films but in the table but the may not have the same films showing)</p>
  
  <p>Here is what i have come up with but I run into a problem as when the "SELECT DISTINCT" returns more than one result it obviously cant be matched with the FilmName on tbl Films.
  How can i check this value for all FilmNames on tblFilms?</p>
  
  <pre><code>SELECT * 
  FROM tblFilms
  WHERE FilmName = (SELECT DISTINCT FilmName FROM tblListings WHERE Cimema = 1)
  </code></pre>