dear all,

I meet this problem, I have 2 tables, CLASS and STUDENT

I am trying to run this sql:
select class.class_id, minScore from
CLASS class,
(
select class_id, min(score) as minScore
FROM STUDENT GROUP BY class_id
)A
where class.class_id = A.class_id
AND A.minScore<60

This sql is right, but I tried many times , and can't change it to hql, can any one help me? Thank you very much!!!

BTW, I have modles classes generated by middleGen.

cathysuo

the only way you have for writing your SQL is the createSQLQuery
function. It's not possible to do that with HQL only. I am talking about
the SELECT you are doing in the FROM.

I think also it's possible to use HQL if you change your query. Maybe that
querie it's the same that yours :

select ST.class_id, min(score) AS minScore
From STUDENT AS ST
GROUP BY ST.class_id
HAVING min(score) < 60

??