In database forum noone did help me, but since `m writing an example for Seam then maybe you can help me out. My mappings: Category has products and parameters. Every Product has parameter entries(entry) and entry has parameter. Basically I need to query out those parameters in the group that products has no entry for yet. Tried different versions but none got me further.
My current version: List listItems = em.createQuery( "from Parameter p join p.category c join c.products k join k.entries e where k.name = :product" + " and e.parameter != p order by p.priority").setParameter("product",product).getResultList();