I am having trouble figuring out how to define a query, if anyone can help it would be much appreciated. My entity model is something like

User
has many UserGroups

Group
has many ToolGroups
has many UserGroups

Tool
has many toolGroups

ToolGroup
has a Tool
has a Group

UserGroup
has a User
has a Group

I need a query that will list all the ToolGroups for a given Tool/User - in SQL it would be:

select tg.*
from tblUserGroup ug

inner join tblToolGroup tg on tg.GroupId=ug.GroupId

where
ug.UserId=@UserId
and tg.ToolId=@ToolId


1) How would this be done in NHibernate?
2) Can it be done in NHibernate using a Criteria Query?

Thank you so much!!!

Nevermind! I found the solution...