Hello, I need to create a DetachedCriteria for two types without association.

Course
------------
id, name

Teacher
-----------
id, name

Review
--------------
type, id, score

Review type can be Course, or Teacher. Id is the course id or teacher id depending on type.

Query is: list all teachers reviewed order by score desc.

HQL:
select t from Teacher t, Review r where r.type='Teacher' and r.id=t.id order by r.score desc

Is there a way to write the HQL query using DetachedCriteria?

Thanks for help.
Dave