Please use the user forum for user questions.
/max
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.
-- Max Rydahl Andersen callto://max.rydahl.andersen
Hibernate [EMAIL PROTECTED] http://hibernate.org
JBoss Inc [EMAIL PROTECTED] http://jboss.com
-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now. http://productguide.itmanagersjournal.com/
_______________________________________________
hibernate-devel mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/hibernate-devel
