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
|