Hello,
I've found an example for a HQL-Select statement using "with" for additional conditions on the join-element (hibernate 3.1?).

This would be very useful, because I'd like to get some data like this:

select A.someprop, T1.someprop, T2.someprop
from A
left join A.T as T1 with T1.propx = "A"
left join A.T as T2 with T2.propx = "B"
where (T1.propx = "A" or T2.propx = "B")

to get the result (for example):

A.someprop | T1.someprop | T2.someprop
---------------------------------------------------
1 | null | 3
2 | 3 | 5
3 | 8 | null
4 | 12 | 26

Have you any information, if this feature is planned - I didn't found this in the issue list or can I solve this in an unusual manner.

Thanks for your information, Thomas.

It's already logged: http://jira.nhibernate.org/browse/NH-514

Please go to JIRA and vote for it ...