Sergey Lysenko edited a comment on HHH-7321

Re: HQL: Combining a CROSS JOIN with a LEFT JOIN which requires a WITH clause triggers an exception. Hi, I have the same issue. For example, there are three table:  {quote} A(id,some_date); B(id,a_id); C(id, a_id b_id ,date); {quote} I want write following query: {quote} select * from a left join b on a.id=b.id left join c on  a  b .id = c.id and c.date < a.some_date; {quote} Please, say me how I can write this query on HQL because I have following exception: Caused by: org.hibernate.hql.internal.ast.QuerySyntaxException: with-clause referenced two different from-clause elements Add Comment

This message was sent by Atlassian JIRA (v6.2-OD-07-027#6211-sha1:e698eb6)