title: How can retrieve Answer and Question table in back end with sql query like this?
body: <p>I'm using Servlet JSP SQL to write Quiz Application</p>
  <p>I have two table in sql like this:</p>
  <pre><code>Question(questionID, question_content, status, subjectID)
  
  Choice(choiceID, choice_content, questionID, isTrue)
  </code></pre>
  <p>1 Question will have 4 answers (1 true - 3 false)</p>
  <p>here is my query:</p>
  <pre><code>SELECT *, question_content
  FROM Choice 
  INNER JOIN Choice.questionID = Question.questionID
  </code></pre>
  <p>So result will be like this:</p>
  <p>Question 1 - Choice1</p>
  <p>Question 1 - Choice2</p>
  <p>Question 1 - Choice3</p>
  <p>Question 1 - Choice4</p>
  <p>...</p>
  <p>So the object I receive in back end will like</p>
  <p>Obj(Question1, Choice1)</p>
  <p>Obj(Question1, Choice2)</p>
  <p>...</p>
  <p>But what I want is:</p>
  <p>Obj(Question1, Choice1, Choice2, Choice3, Choice4)</p>
  <p>Is there any way to achieve this or any query suit my need?</p>