Join on subquery currently works only in hql (implemented in v5.4: https://github.com/nhibernate/nhibernate-core/pull/2551). As of NHibernate v5.5.x, LINQ support is not yet implemented.