[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-892?page=co... ] Ben Wong commented on HHH-892: ------------------------------ The workaround works only for simple query. For query such as: select c.id, c.customer, (select count(s.totalSales) from sales s where s.customer = c and s.customerType = 4) as totalSales, (select count(ex.totalExpense) from expenses ex where ex.customer = c and ex.customerType = 4) as totalExpenses from customer c order by totalSales / totalExpenses, c.id The above is an example I made up, but that's what I am trying to do with my (more) complex HQL query. Unless I am wrong, I don't think you can stick subselect clauses in the order by. P.S. I don't mean to whine, but how hard is it to replace the alias in the order by clause with the generated ones by Hibernate when generating the SQL from HQL? I would think this is a simple fix (or enhancement). Ben -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira