[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-879?page=co... ] Simon Oualid commented on HHH-879: ---------------------------------- Simplest workaround I found : {code} Restrictions.sqlRestriction( " exists ( select null from BaseEntity be2, ChildEntity ce1, ChildEntity ce2 " + "where be2.id = baseentity1_.id and ce1.id_parent = be2.id and ce2.id_parent = be2.id " + "and ce1.id = "+ firstEntityId +" and ce2.id = "+ secondEntityId +") " ); baseEntityCriteria.add( r ); {code} Regards. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira