title: Join in play framework
body: <p>i have never use jpa and i would like to ask if there is a join</p>
  
  <p>if i do this </p>
  
  <pre><code>String queryStringGet="SELECT c.* FROM Category c "+
  
  "LEFT JOIN User us ON us.id = c.id "+
  
  "+"WHERE c.user_id="+id;
  
  List&lt;Object[]&gt; list = JPA.em().createNativeQuery(queryString).getResultList();
  </code></pre>
  
  <p>Works but comes out as an object, and i don't know how to list in the view :(</p>
  
  <p>Since play.db.jpa.Model  does not suport ON how do i do a join ?
  and how do i List the objects?</p>
  
  <p>Thanks</p>