Hi people,

I've started using Hibernate 3 days ago :)

what I want is to get HQL of this MySQL code:

select result.id as candidates from (select count(0) mycount, GraduateQualification.Grad_id as id from GraduateQualification where GraduateQualification.Qual_id in (1,2) group by GraduateQualification.Grad_id) as result where result.mycount = 2



GraduateQualification is a mapping class from Hibernate

help me, plz

Regards,
Bassam

Hi,

If you refer to section 14.13 page 153 of HIbernate 3.2.2 documentation, there's a note mentioned "Note that HQL subqueries may occur only in the select or where clauses."

So, I guess using HQL subquery in from clause may not be possible.

Hope some senior Hibernate core users / developer can comment on this.

Indeed virtual tables are not currently supported by HQL. This may change in the future.