title: LEFT JOIN using OR
body: <p>I was wondering how I would return the result of the left most condition in  <code>OR</code> clause used in a <code>LEFT JOIN</code> if both evaluate to be <code>true</code>.</p>
  
  <p>The solutions I've come upon thus far both involve using <code>CASE</code> statement in the <code>SELECT</code>, this does mean I'd abandon the <code>OR</code> clause.</p>
  
  <p>The other solution involved using a <code>CASE</code> statement in an <code>ORDER BY</code>.</p>
  
  <p>Is there any other solutions that would cut down on the use of <code>CASE</code> statements. Reason I ask is because as or now there's only two <code>LEFT JOIN</code>s but over time more will be added.</p>
  
  <pre><code>SELECT item.id,
         item.part_number,
         lang.data AS name,
         lang2.data AS description
    FROM item
         LEFT JOIN
         language lang
            ON     item.id = lang.item
               AND (lang.language = 'fr' OR lang.language = 'en')
         LEFT JOIN
         language lang2
            ON     item.id = lang2.item
               AND (lang2.language = 'fr' OR lang2.language = 'en')
   WHERE item.part_number = '34KM003KL'
  </code></pre>