title: Ordering a join fetched collection in JPA using JPQL/HQL
body: <p>Given the below JPQL statement, how do I modify it so that the kittens in the resulting list are ordered by their <code>age</code> property?</p>
  
  <pre><code>SELECT c FROM Cat c left join fetch c.kittens WHERE c.id = :id
  </code></pre>
  
  <p>I've tried multiple approches but without any luck. This is esentially what I would like to do, but it doesn't work:</p>
  
  <pre><code>SELECT c FROM Cat c left join fetch c.kittens k WHERE c.id = :id ORDER BY k.age
  </code></pre>