Oh! sorry for reply On Sep 17, 2:51 pm, alexey_baranov <[email protected]> wrote: > Hello! > > We are trying to fetch all Persons inside Department wich art not > inside subdepartments and got the following exception. Help us catch > our error. > > NHibernate.Hql.Ast.ANTLR.SemanticException: Path expected for join! [ > select p > from > Helpdesk.Person p > left join Department d on p.Path like d.Path + > cast(d.Id as String) + '/%' > where > p.Path like :rootDepartmentPath2 + '%' > and d.Path like :rootDepartmentPath2 + '%' > and d is null > ]. > > Thanks!
-- You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/nhusers?hl=en.
