Hi!
Our legacy app there is this interesting feature that Order master table is splitted into two tables
Order_Master and Order_Master_History. In Order_Master table there are all today orders and Order_Master_History table will have all historical info.
The new integration app I write would need to benefit on those two tables as union query. But how should I map the nhibernate OrderMaster entity so I could execute additional HQL queries against this mapping?