Hi
I'm new to Hibernate, and want to convert my SQL query to Hibernate query (Criteria/HQL/?):
Code:
select temp.a,temp.b,temp.c,mm.d
from main_table mm, (select count(x) as a, id as b, max(y) c
from main_table where z<100 group by id) temp
where mm.id=temp.id and mm.id not (select id from deleted_main)

Above is an example query in SQL, which I want to convert in Hibernate criteria mainly since as much I read we can't have a query in from clause in HQL.
Could someone please help me in structuring a DetachedCriteria query for above Sql?

PS: Re-Posting the topic since last post was gone in SPPAM

TIA
Nitin