if your situation is what you said it is (table1, table2, table3) why wouldn't you want a refenrece from class3 to class2 (there is a foreign key, its not an arbitrary join by some arbitrary column, it is by the foreign key). if you set a reference, you can just say
from class3 where class3.Class2Reference.SomeProperty = x NH will do the join for you and you'll get the exact sql you were expecting -- 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.
