title: Join multiple tables with one JPQL query
body: <p>I got this sql-query I want to create as query in JPQL but I cannot get it right. I got a manytoone relationship between QuestionAnswers and QuizQuestions:</p>
  
  <p>SQL:</p>
  
  <pre><code>SELECT quizName, question, answer FROM Quiz 
  JOIN QuizQuestions on Quiz.quizId = QuizQuestions.Quiz_QuizId 
  JOIN QuestionAnswers on QuizQuestions.questionId = QuestionAnswers.question_questionId 
  WHERE quiz.quizId = 1;
  </code></pre>
  
  <p>JPQL query:</p>
  
  <pre><code>Query query = entityManager.createQuery("SELECT q.quizName, f.question, a.answer FROM Quiz q, QuizQuestions f, QuestionAnswers a LEFT JOIN QuestionAnswers ON f.questionId=a.question.questionId");
  </code></pre>
  
  <p>I get syntax error in Intellij. </p>
  
  <p>What can be wrong?</p>
  
  <p>Im using EclipseLink</p>
  
  <p><strong>EDIT</strong>
  solved it like this with just one join:</p>
  
  <pre><code>Query query = entityManager.createQuery("SELECT f.quiz.quizName FROM QuizQuestions f JOIN QuestionAnswers qa WHERE f.questionId = qa.question.questionId");
  </code></pre>