Are you looking for an example with JPQL? If yes, see this http://java.sun.com/javaee/5/docs/tutorial/backup/update3/doc/QueryLanguage3.html View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4190759#4190759 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4190759