You can just write it the old school way, by making a cartesian product and filter it in the where clause:
from Parent p, Child c where p.Iid = c.FkIid On 7 Sep., 08:18, merrycoder <[email protected]> wrote: > Thanks for the answer, Fabio. Unfortunately this doesn't solve my > issue. In your example there is a mapping between the entities. > My entities don't have any relation mapping. I need to fully(!) define > the join clause from hql. > > Greetings > > Stefan Landgraf > > On 6 Sep., 15:28, Fabio Maulo <[email protected]> wrote: > > >http://fabiomaulo.blogspot.com/2009/05/nhibernate-210-hql-with-clause... > > > 2009/9/6 merrycoder <[email protected]> > > > > What I am looking for is a possibility to Join unmapped entities in > > > HQL resulting in an SQL JOIN with user defined ON criteria. > > > In HQL the “join” will be transformed into a ON clause based on the > > > mapping of the property. As my entities have no relationship mappings > > > this doesn’t work for me. > > > > What I need is something like > > > > from Parent p > > > inner join p, Child c on p.Iid=c.FkIid > > > but this fails with “Path expected for join!” > > > > Is there a bypass or other trick for this? Is there maybe a > > > possibility to define my own hql commands and inject them into the hql > > > processor? > > > > Any help would be greatly appreciated! > > > > Thank you > > > > Stefan Landgraf > > > -- > > Fabio Maulo --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
