[nhusers] How to map many-to many to achieve select in()

[thecodefool]

Hi my question, I hope is a simple one

I have four tables

TableA
  TableAId
  Name

TableB
  TableBId
  Name

TableBType
 TableBTypeId
 Name


TableA_TableB
 TableAId
 TableBId
 TableBTypeId

I have normal classes for each nothing fancy, but I do not have a
class TableA_TableB (Not sure what to do)

I would like to create the following using an ICriteria but I cannot
for the life of me figure it out.


SELECT a.* FROM TableA a
INNER JOIN TableA_TableB ab ON a.TableAId = ab.TableAId
WHERE ab.TableBTypeId IN(1,2,3)

Any help is greatly appreciated

Thanks

-- 
You received this message because you are subscribed to the Google Groups 
"nhusers" group.
To post to this group, send email to nhus...@googlegroups.com.
To unsubscribe from this group, send email to 
nhusers+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/nhusers?hl=en.