I would like to do this with the Criteria API (HB 3.0.2) :

select * from MYTABLE t
where t.NAME like 'DO%' and t.ADATE in (
select max(st.ADATE) from MYTABLE st where st.NAME=t.NAME);

Is it possible with the Criteria API ?

thanks !

Fred

Did you take a look at detached criteria?

http://www.hibernate.org/hib_docs/v3/reference/en/html/querycriteria.html#querycriteria-detachedqueries

-David[/url]

I did not realize that those DetachedCriteria API could be useful to do subqueries.
It works perfectly well !

thank you so much !

Fred