I have the following query using one field with a 'distinct' keyword:

lst = sess.find("select distinct region from us.ut.state.dced.museums.MuseumMain as museumsmain order by region");

It works fine if I start with the word "from", but selecting one field gives me this error:

net.sf.hibernate.QueryException: undefined alias: DISCIPLINE [select distinct DISCIPLINE from us.ut.state.dced.museums.MuseumMain as museumsmain order by dicipline]

What would be the alias I have to use for a field?

Thanks!
Scott

The correct HQL is:


select distinct mm.region
from us.ut.state.dced.museums.MuseumMain as mm
order by mm.region