http://ayende.comAyende @ RahienCopyright (C) Ayende Rahien 2004 - 2021 (c) 202660No, create criteria means that you are now in a sub criteria, so the entity you now refer to is the user. If I would have used the CreateAlias(), then I would have to do so. "user.id" would work as well, btw. http://ayende.com/3119/nhibernate-queries-find-all-users-that-are-members-of-the-same-blogs-as-this-user#comment4http://ayende.com/3119/nhibernate-queries-find-all-users-that-are-members-of-the-same-blogs-as-this-user#comment4Fri, 25 Jan 2008 15:31:21 GMTMaybe I am reading it wrong, but shouldn't the projection be something like .SetProjection(Property.ForName("user.id")) so we get the related user ids? http://ayende.com/3119/nhibernate-queries-find-all-users-that-are-members-of-the-same-blogs-as-this-user#comment3http://ayende.com/3119/nhibernate-queries-find-all-users-that-are-members-of-the-same-blogs-as-this-user#comment3Fri, 25 Jan 2008 15:26:03 GMTJon, Yes, you are correct, I wasn't precise enough. As for skipping the blog's join, it would be valid, but it is likely that using the fully path will allow the DB to utilize the FK indexes. http://ayende.com/3119/nhibernate-queries-find-all-users-that-are-members-of-the-same-blogs-as-this-user#comment2http://ayende.com/3119/nhibernate-queries-find-all-users-that-are-members-of-the-same-blogs-as-this-user#comment2Thu, 24 Jan 2008 15:56:22 GMTI'm probably being stupid, but doesn't that SQL find the users that are members of *any* of the same blogs that the specified user is a member of? (Rather than all, as specified in the post.) And out of interest, am I right in saying we don't actually need the join to Blogs at all? Assuming there are appropriate constraints, the subselect could be: SELECT this_0_.Id AS y0_ FROM Users this_0_ INNER JOIN UsersBlogs blogs4_ ON this_0_.Id = blogs4_.UserId INNER JOIN UsersBlogs users6_ ON blogs4_.BlogId = users6_.BlogId INNER JOIN Users user2_ ON users6_.UserId = user2_.Id WHERE this_0_.Id = @p0 Hopefully the query optimiser in the DB would figure this out though :) Jon http://ayende.com/3119/nhibernate-queries-find-all-users-that-are-members-of-the-same-blogs-as-this-user#comment1http://ayende.com/3119/nhibernate-queries-find-all-users-that-are-members-of-the-same-blogs-as-this-user#comment1Thu, 24 Jan 2008 14:58:17 GMT