I'm new to nhibernate and I'm stumped by something that I believe should be easy to achieve. Essentially I have 2 tables in my model, say Company and Employee, representing a one to many relationship. I want to filter the employee rows returned based on values from a third table that I do not want to include in my model (as I need no data from it). Is this possible, I can't see an obvious solution.
Essentially I'm trying to achieve a join such as: SELECT * FROM company c JOIN employee e ON e.companyid = c.companyid JOIN payroll p ON p.employee = c.employeeid WHERE p.blah = 'blah' Any help greatfully recieved. -- 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.
