Hi. try this:
SELECT DISTINCT m FROM Material m, IN(m.suppliers) s WHERE m.unit <> Material$MaterialUnit.SQUARE_METRES AND s.id = :id I am not sure if you will need the package name before Material. Cheers, Andy View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4020649#4020649 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4020649 _______________________________________________ jboss-user mailing list [email protected] https://lists.jboss.org/mailman/listinfo/jboss-user
