From what I've understood this is *not* possible with JPA-QL
because all outer joins are a special form of relationship joins and therefore require a
relationship to refer to. So you only have a chance using SQL in your case. In some
special cases you can use sub-selects as a work-around.
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4023807#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...