I'll give you a hint however. Check page 281 ;-)
Emmanuel Bernard 01.55.21.52.14 Fnac - DSI Direction France - Nouvelles technologies 67, boulevard du Gal Leclerc 92612 Clichy Cedex
Max Rydahl Andersen wrote:
On Thu, 2 Dec 2004 03:36:43 -0800 (PST), Vinay Gajjala <[EMAIL PROTECTED]> wrote:
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.
-------------------------------------------------------
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
