title: Merge two rows in SQL
body: <p>Assuming I have a table containing the following information:</p>
  
  <pre><code>FK | Field1 | Field2
  =====================
  3  | ABC    | *NULL*
  3  | *NULL* | DEF
  </code></pre>
  
  <p>is there a way I can perform a select on the table to get the following</p>
  
  <pre><code>FK | Field1 | Field2
  =====================
  3  | ABC    | DEF
  </code></pre>
  
  <p>Thanks</p>
  
  <p>Edit: Fix field2 name for clarity</p>