hi all,

i want to know how to use an inner query in Criteria. i have set the values of the column and one condition requires that the column has the max version.

i want to create a query like this :

SELECT * FROM TABLE1
WHERE NAME='AD_JOB'
AND EVENT=1
AND JOBVERSION = (SELECT MAX(JOBVERSION) FROM TABLE1 WHERE NAME='AD_JOB')

i have criteria for setting name and event conditions. i am unaware of how to set for job version. plz do reply

Check detached criteria, if I remember well, you can handle sub query with it.

Thanks buddy... DetachedCriteria solves the Problem!!!