Hi, I'm trying to implement the following query in HQL select <something> from table_a left outer join ( table_b inner join table_c on table_c.b_id=table_b.id and <some condition on table_c> ) on table_b.a_id=table_a.id
The HQL should look something like: from A left join (A.Bs as b join b.C c with <some condition on c>) but the parentheses give me an error: NHibernate.Hql.Ast.ANTLR.QuerySyntaxException : Exception of type 'Antlr.Runtime.NoViableAltException' was thrown. Without the parentheses it works just fine, but the results are obviously not desired. Is there any way to have a nested inner join in HQL? Many thanks, Rafał -- You received this message because you are subscribed to the Google Groups "nhusers" group. To view this discussion on the web visit https://groups.google.com/d/msg/nhusers/-/HK31ukge8N0J. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/nhusers?hl=en.
