title: Make 1 row out of many rows from another table
body: <p>I have a MSSQL database which in one table holds bio info about a person:</p>
  
  <pre><code>ID: Name : Age : Sex
  </code></pre>
  
  <p>In another table it holds their answers to a number of questions like this:</p>
  
  <pre><code>PersonID : QuestionID : Answer
  </code></pre>
  
  <p>Is it possible to display all of them via MSSQLMSE into one record like this:</p>
  
  <pre><code>ID : Name : Age : Sex : Question1Answer : Question2Answer : Question3Answer : And so on?
  </code></pre>