title: MYSQL select query based on another tables entries
body: <p>I have stumped on this as I am a total beginner in MySql.</p>
  <p>Here is a the basic of how the two tables are formed</p>
  <blockquote>
  <p>Table 1
  id,product_id, product_name</p>
  <p>Table 2
  id,product_id,active</p>
  </blockquote>
  <p>Now i know how to do a select statement to query the results from one table but when I have to involve two, I am lost.  Not sure if I have to use inner join, left join etc.</p>
  <p>So how can I return the results of the product_id from table 1 only if in table 2 is active?</p>