title: (SQL) Query Results on one row
body: <p>So I have two tables, named "Questions" and Answers
  <a href="https://i.stack.imgur.com/W5Vyg.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/W5Vyg.png" alt="Diagramm"></a></p>
  
  <p>I made a INNER JOIN for those two tables</p>
  
  <pre><code>SELECT Questions.ID, Questions.QText, Answers.AText
  FROM Questions INNER JOIN Answers
  ON Questions.ID=Answers.QuestionID;
  </code></pre>
  
  <p>And the result looks like this:
  <a href="https://i.stack.imgur.com/SmsMo.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/SmsMo.png" alt="Result"></a>
  However, you can clearly see, that the question is displayed 4 times each time with on of the answers. </p>
  
  <p>Now My question is: Is it possible to have the result in one row, consisting of </p>
  
  <p>[ID] - [Question] - [Answer1] - [Answer2] - [Answer3] - [Answer4]</p>