posted 17 years ago
I have the following query where I want to add further restrictions to the join join clause. I am using the 'wtih' keyword as in written in the hibernate docs. However, I am always getting the following error a org.hibernate.hql.ast.QuerySyntaxError: unexpected token. If I take out 'with p.deleted is null' it works.
from Category as c
left join fetch c.member
left join fetch c.photos as p with p.deleted is null
where c.id = :categoryId
and c.member.id = :memberId
Does anyone know how to get this working?
thank you
david