I receive this error message: with-clause referenced two different from-clause elements
when I attempt to execute this HQL statement: select iho.CODE, al1.CODE from IHObjekt iho left outer join iho.attributValue av3 with (av3.ATTRIBUTDEF_ID=4894477) left outer join av3.attributLookup al1 with (al1.ID=av3.NUMERICVALUE) It is caused by the association between 2 left outer joins in the al1.ID=av3.NUMERICVALUE. When I replace av3.NUMERICVALUE with a numeric value it executes but I get the wrong results. My iho.attributValue is an IList / bag. My iho.attributValue.attributLookup (av3.attributLookup) is an IList / bag (I do use the property-def parameter in this one becuase their is no Primary of Foreign relationship between the 2 joined tables) Any ideas on why this error happens and/or a solution? -- You received this message because you are subscribed to the Google Groups "nhusers" group. 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.
