I have an hql statement I'm trying to write that's a beyond the normal scope of stuff I've written todate using NHibernate. I was able to write the statement in normal MSSQL but realized I don't know how to do it in HQL. I have an object called A which has a collection of B objects. B has a property called C. I'd like to be able to get all of the A's that have B.C = 'qwerty'. When I CreateQuery and do a "FROM A a WHERE a.Name = 'asdf'" I get back a fully populated A with a collection of B's. When I saw that I thought I probably didn't need a join since NHibernate was seeing the connection. I'm extremely stumped. If anyone has an idea I'd love to hear it - thanx!