title: LEFT OUTER JOIN with WHERE clause on 2nd table, not effecting 1st table
body: <p>I'm trying to return a set of records from two tables.
  I'm using <code>LEFT OUTER JOIN</code>, because I want all data from table 1.
  I only want the data from table 2 <code>JOINED</code> if a certain clause is met.</p>
  
  <p>The clause seems to be overriding the <code>LEFT OUTER JOIN</code> and not returning records from table 1, if a record from table 2 doesn't meet the <code>WHERE</code> clause.</p>
  
  <pre><code>SELECT p.code, p.name, d.product_code, d.detail_type, d.description
    FROM products p
    LEFT OUTER JOIN product_details d
      ON p.code = d.product_code 
   WHERE product_details.detail_type = 'ALTERNATIVE NAMES'
  </code></pre>
  
  <p>I want all rows from products returned, but I only want rows from <code>product_details</code> to be joined if <code>product_details.detail_type = 'ALTERNATIVE NAMES'</code></p>
  
  <p>I'm looking for some guidance as to whether this is possible or if I should be stripping out the unwanted data after the initial <code>JOIN</code>?</p>