My latest attempt was this HQL (simplified the query to focus on the
m2m relationship):
select audit.Id
from Audit audit join audit.AuditTypes as at
where at.Id IN (1,2,3,4,5,6,7)

This was the resulting SQL (the in between table WAS referenced, but
the where clause was DROPPED!):
select audit0_.Id as col_0_0_
from audits audit0_ inner join audit_auditTypes audittypes1_ on
audit0_.Id=audittypes1_.auditId
inner join audittypes audittype2_ on
audittypes1_.auditTypeId=audittype2_.Id


On Jan 21, 10:31 am, Fabio Maulo <[email protected]> wrote:
> 2010/1/21 welzie <[email protected]>
>
> > So it seems that join does not work for many-to-many.  Is that
> > correct?
>
> If you have a failing test, with correct mappings and
> entities-implementation, then: Yes, that is correct.
> --
> 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.


Reply via email to