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 --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
