orselect p.Country.Name from Site s join s.Parent p with p.Country = s.Country 2009/9/1 Fabio Maulo <[email protected]>
> but I don't understand your designselect > p.Country.Name<http://Parent.Country.Name> from > Site s join s.Parent p join s.Country c > > perhaps should be > select c.Name <http://Parent.Country.Name> from Site s join s.Parent > p join s.Country c > > or should be > select c.Name <http://Parent.Country.Name> from Site s join s.Parent > p join p.Country c > > or in your domain a child Site can have a different "Country" than the > Parent-Site ? > > 2009/9/1 Gabriele Tassi <[email protected]> > > >> As for the query with lower-case aliases, same problem, same generated >> Sql ;( >> >> >> >> > > > -- > Fabio Maulo > -- 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 -~----------~----~----~----~------~----~------~--~---
