title: sql query to get data from two tables
body: <p>I have two tables</p>
  
  <p>In table 1 I have</p>
  
  <pre><code>movie_id, movie_name
  </code></pre>
  
  <p>In table_2 I have</p>
  
  <pre><code>movie_id,movie_genre 
  </code></pre>
  
  <p>Now I want to know the the names of movie which belongs to particular genre</p>
  
  <p>What should my query look like??
  Thanks</p>