title: hibernate order by association
body: <p>I'm using Hibernate 3.2, and using criteria to build a query. I'd like to add and "order by" for a many-to-one association, but I don't see how that can be done. 
  The Hibernate query would end up looking like this, I guess:</p>
  
  <pre><code>select t1.a, t1.b, t1.c, t2.dd, t2.ee
  from t1
  inner join t2 on t1.a = t2.aa
  order by t2.dd   &lt;-- need to add this
  </code></pre>
  
  <p>I've tried criteria.addOrder("assnName.propertyName") but it doesn't work. I know it can be done for normal properties. Am I missing something?</p>