http://fabiomaulo.blogspot.com/2009/09/nhibernate-queries.html
Note: SQL is one of your options 2010/1/20 welzie <[email protected]> > > Thanks for the suggestion, but that creates this SQL which does NOT > join the tables using the "in between table". I end up with duplicate > results. > select audit0_.Id as Id9_, > audit0_.Active as Active9_, > audit0_.DateAudited as DateAudi3_9_, > audit0_.AuditorId as AuditorId9_, > audit0_.ClaimId as ClaimId9_, > audit0_.SpecialProjectId as SpecialP6_9_ > from audits audit0_, audittypes audittype1_ > where audittype1_.Id in (1,2,3,4,5) > > What I really need is HQL to create SQL that looks like the below. > Any more suggestions? > select * > from audits > join audit_audittypes on audit_audittypes.auditId = audits.id > join auditTypes as at on at.id = audit_audittypes.auditTypeId > where at.id IN (1,2,3,4,5,6,7) > > On Jan 20, 5:10 pm, Graham Bunce <[email protected]> wrote: > > Something like; > > > > SELECT au FROM Audit au JOIN au.AuditTypes at > > WHERE at.id IN (:ids) > > > > I think > > -- > 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]<nhusers%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/nhusers?hl=en. > > > > -- 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.
