BTW, this is an outer join, where some Locations will not have Areas associated with them at all. View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3977075#3977075 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3977075