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(); View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3936808#3936808 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3936808 ------------------------------------------------------- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642 _______________________________________________ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user