title: Inner Join apply condition to only one table
body: <p>Here is my query:</p>
  
  <pre><code>SELECT p.product_id,p.title,p.price,p.total_sales,p.total_revenue,p.timestamp,i.image_id
  FROM products AS p
  INNER JOIN products_images AS i
  ON p.product_id = i.product_id
  WHERE p.account_id = ? AND p.deleted=0 AND i.featured=1
  </code></pre>
  
  <p>I want to get <code>i.image_id WHERE i.featured = 1</code> but I don't know how to apply that condition so that it only applies to the images table. The query works but I don't get all my results from the products table, just one row. </p>
  
  <p>Obviously in some cases there might not be an image_id available where featured=1. So it would have to spit out something else in that case.</p>