order by with sub-select ------------------------ Key: HHH-3118 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3118 Project: Hibernate3 Issue Type: Improvement Components: query-hql Affects Versions: 3.2.3 Reporter: Magnus Sandberg I'd like to order by a column that is created with a sub-select: select a.b, (select c from [...]) from [...] where [...]; naming the sub-select column does not work: select a.b, (select c from [...]) as to_order from [...] where [...] order by to_order; gives a "no such column" exception. I think hql should accept order by from named columns. -- 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