Hello,

I know this topic has been already discussed couple of time, but I could not find a definite answer even after spending an hour reviewing existing posts.

Is there any way to write a Criteria that selects from another DetachedCriteria? So the result SQL would be something like Select * FROM (Select ...

I have already spent couple of hours with this and if it is not possible, I would really like to know (and if it is possible, I would really like to know how of course :-) )

I am also interested if there is a way to do a JOIN with a subquery using Criteria.

Best regards,

Dusan