Hi

I have a mapping for events in a module class where event is the base class. Event is also sublclassed to interview which is a joined subclass. I do a query on modules which has a list of events as a property, and when the query is generated the sql instead of doing a join between module and events, it does a left outer join with the interview class, even though the interview class isnt referred to. My hunch is that you cant do alias on the base class, and that nhibernate then works out any path it can find to join the two tables, ie module and interview that it can.

Can I do an alias on a base, with a joined subclass mapping? If I can how can I force it to use the base class and not a subclass

Thanks in advance, Ive been all over this and the only work around Ive got is to use subqueries and split the query out