[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-3749?page=c... ] Steve Ebersole updated HHH-3749: -------------------------------- Description: Consider: select ( select clasn1.name from riskClasns_Contxt0.clasn as clasn1 ) as policyType from Risk as risk0 inner join risk0.riskClasns_Contxt as riskClasns_Contxt0 inner join riskClasns_Contxt0.clasn as clasn0 inner join clasn0.clasnScheme as clasnScheme0 Currently we miss the conditions needed in the subquery because we reuse the from element corresponding to riskClasns_Contxt0.clasn from the outer query. Again the solution is to recognize that each has a different alias indicating that we should not reuse the FromElement from the outer query here. alias matching here needs to consider null as never matching was: Consider: select ( select clasn1.name from riskClasns_Contxt0.clasn as clasn1 ) as policyType from Risk as risk0 inner join risk0.riskClasns_Contxt as riskClasns_Contxt0 inner join riskClasns_Contxt0.clasn as clasn0 inner join clasn0.clasnScheme as clasnScheme0 Currently we miss the conditions needed in the subquery because we reuse the from element corresponding to riskClasns_Contxt0.clasn from the outer query. Again the solution is to recognize that each has a different alias indicating that we should not reuse the FromElement from the outer query here. Summary: Only reuse FromElements originating from from-clause if their aliases match (was: Only reuse FromElements originatng from from-clause if their aliases match) -- 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