Hi, I have the same issue. For example, there are three table:

A(id,some_date);
B(id,a_id);
C(id,a_id,date);

I want write following query:

select *
from a
left join b on a.id=b.id
left join c on a.id = c.id and c.date < a.some_date;

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