This question is about how to formulate the ejbql? You'll need to ask that on the hibernate jpa forum. View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4100564#4100564 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4100564