<class name="com.fundserv.aia.persistent.ABC" table="ABC">
<id name="id" column="ID"/>
<property name="keyid" column="KEYID"/>
<join table="BCD" inverse="true">
<key column="KEYID"/>
<property name="myinfo" column="info"/>
</join>
</class>


Above mapping retrieve myinfo data from BCD.info column by comparing ABC.ID = BCD.KEYID.

What changes does it need so that myinfo property retrieves from BCD.info by comparing ABC.KEYID = BCD.KEYID????? [Keep in mind that ABC.KEYID should never be a part of the primary key]


Would the following solves the problem?

<property formula='.......'/>

This is very impolite.