You need to show the mappings for all classes used in the query, so that we can help you. Most likely you have not created an association of one class to another in the mappings.
John Davidson. On Fri, Sep 17, 2010 at 4:56 AM, alexey_baranov <[email protected]> wrote: > 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]<nhusers%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/nhusers?hl=en. > > -- 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.
