I have no idea if this will work, or even if it's legal HQL, but the first thing I would try is | SELECT OBJECT(o) FROM ChargingPoint AS o, IN(o.history) AS h RIGHT JOIN SubNetwork n | WHERE h.isActive = true | AND h.beginDate <= ?2 AND (h.endDate IS NULL OR h.endDate > ?2) | AND (h.downstreamSubNetwork = n OR h.upstreamSubNetwork = n) | AND (n = ?1) | ORDER BY o.identifier | View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3966803#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...