I use the example from hibernate document.

Here is mapping from document and I add one more line for "otherId" property.

<class name="eg.Parent">
<id name="id" column="id"/>
<property name="otherId" column="other_id" />
....
<set name="children" inverse="true" lazy="true">
<key column="parent_id"/>
<one-to-many class="eg.Child"/>
</set>
</class>

The one-to-many relation is equivalent to:

select children from TBL_child as c where c.parent_id = id;

The last "id" after equal sign is from parent.

Now I changed it to "other_id" which corresponds to other column in the parent table,

select children from TBL_child as c where c.parent_id = other_id;

How can I get this mapping?

Thanks