title: SQL: How to return an non-existing row?
body: <p>Say I have the following table:</p>
  
  <pre><code>=================================================
  | color_id | parent_id | language_id | name     |
  =================================================
  | 1        | 50        | 1           | Black    |
  -------------------------------------------------
  </code></pre>
  
  <p>Then say I need the row <code>WHERE parent_id = 50 AND language_id = 2</code>. Obviously, I would get nothing back based on my example table. However, I still need a result -- probably something like this:</p>
  
  <pre><code>=================================================
  | color_id | parent_id | language_id | name     |
  =================================================
  | NULL     | 50        | 2           | NULL     |
  -------------------------------------------------
  </code></pre>
  
  <p>Is there a way to do this in SQL?</p>