Hello,
At the end of this page http://docs.jboss.org/hibernate/core/3.3/reference/en/html/associations. (The very last block), it is using subselect on the join element, I have tried to implement something similar but it doesn't seem like the subselect does anything, whatever I put in the subselect the generated sql doesn't get affected. <class name="Account " table="Account" lazy="true"> <id name="AccountId" column="AccountId" type="int"> <generator class="" /> </id> <property name="Name" column="Name" type="string" not-null="true" /> <join table="AccountSetting"> <subselect> select accountId , accountSettingIndex, brandId from AccountSetting group by accountId having accountSettingIndex = max(accountSettingIndex) </subselect> <key column="accountId" /> <property name="BrandId" column="brandId" type="int" /> </join> </class> Where can I find some documentation for NHibernate and this subselect element in the join? Thanks, Seif -- 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.
