title: LEFT JOIN ON() in JPQL
body: <p>I have two entities:</p>
  
  <ul>
  <li><code>User</code>: id:<em>long</em>, name:<em>String</em></li>
  <li><code>Player</code>: id:<em>long</em>, owner:<em>User</em>, points:<em>int</em></li>
  </ul>
  
  <p>Now I want to select a User and his associated Player in one JPQL query. In SQL I'd do it like this:</p>
  
  <pre><code>SELECT u.*, p.* FROM User u
  LEFT JOIN Player p ON (p.owner_id = u.id)
  WHERE u.name = ...
  </code></pre>
  
  <p>My first instinct was to do it like this in JPQL</p>
  
  <pre><code>SELECT u, p FROM User u LEFT JOIN Player p ON (p.owner = u) WHERE u.name = ...
  </code></pre>
  
  <p>But I don't think the <code>ON</code> clause is supported in JPQL. I do need it however, because <code>User</code> has no reference to <code>Player</code> (many things other than <code>Player</code> could be attached to a <code>User</code>).
  How can I solve this one?</p>