title: How to merge db rows together?
body: <p>I have a query below which displays these results:</p>
  
  <pre><code>SELECT q.QuestionId, q.QuestionContent, an.Answer
  FROM Answer an
  INNER JOIN Question q ON q.AnswerId = an.AnswerId;
  </code></pre>
  
  <p>Result of query:</p>
  
  <pre><code>QuestionId     QuestionContent           Answer
  1              Who are me and you         B
  1              Who are me and you         D
  2              Name these Cars            A
  2              Name these Cars            B
  2              Name these Cars            E
  3              What is 2+2                B
  </code></pre>
  
  <p>What I want to do is merge the answers together for the same QuestionId so the result looks like this below:</p>
  
  <pre><code>QuestionId     QuestionContent           Answer
  1              Who are me and you         B D
  2              Name these Cars            A B E
  3              What is 2+2                B
  </code></pre>
  
  <p>Is this possible?</p>
  
  <p>Thanks</p>