the join restriction should be placed in the where clause of the ejbql, not as a restriction. View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4116824#4116824 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4116824