title: Column join to merge values
body: <p>I have a table with languages terms. </p>
  
  <pre><code>VAR   |  EN  |   ES   |  FR
  ---------------------------
  CR   |  car | coche  | voiture
  </code></pre>
  
  <p>Default is English and it has all terms, however some other languages, like Spanish of French can have terms missing. I need to run a query and get the terms into an array based on the language, but if the term in that language is missing, I need it to use corresponding English term, instead of having blank value.</p>
  
  <p>I was thinking along the following lines:</p>
  
  <pre><code>SELECT * 
  FROM terms
  WHERE lang = "ES"
  </code></pre>
  
  <p>But I need all VARs and I don't see how I can pull them that way... Just having a mental block, probably need more coffee...</p>