For many-to-one:
<many-to-one name=”rankTypeLookupData”
formula=”(SELECT l.LKP_ID FROM EQ_LOOKUP_DATA l WHERE l.DROPDOWN_CODE = ‘BV_STAFF_RANK_TYPE’ AND l.LKP_KEY = INDVL_RANK_TYPE)”
class=”com……LookupData” not-found=”ignore”>
<column name=”INDVL_RANK_TYPE” />
</many-to-one>
For one-to-many:
<set name=”regionList” table=”BV_REGION” cascade=”all” fetch=”join”
outer-join=”true” where=”DEL_IN = ‘N’” inverse=”true”>
<key column=”INDVL_RANK_ID” />
<one-to-many
class=”com……..StaffTeamRankRegion” />
</set>