[Hibernate] HQL Sub Query

[Vinay Gajjala]

Hi ,

 

   I am a biggner in Hibernate. I want to write a HQL query using sub queries.

   I  through the "Hibernate in Action" book but could not find a suitable answer for my

   problem.

 

   My select query looks like this

 

  Select u.*  from users u

  where u.manager_Id = 1
   and u.id not in (Select User_id from OBJECTIVES where 

                    assigned_Obj_Id in (1,2,3)) 

 

  I have a many-to-one mapping from Objectives to User  in objectives.hbm but not the other

  way round

 

can any body tell me the appropriate HQL Query

 

thanks in advance

Vinay

 

---

Do you Yahoo!?
Take Yahoo! Mail with you! Get it on your mobile phone.