How to write a subquery in hibernate which is having multiple subqueries. for example
select * from project_dtls where project_id in
(select project_id from project_users where user_id =
(select user_id from user_dtls where email='abc@email.com'))
I know that we can write through DetachedCriteria but couldnot find any example where I can use multiple subqueries.
Best Answer
Here's an example:
For multiple subqueries, you can use a boolean operator like Restrictions.or():