I use the following mapping doc for my domain object.

Mapping documents:

<hibernate-mapping package="dictionarytag">

<class name="DictionaryTag" table="resource">
...
<property name="firmId" column="firmId" type="java.lang.Long" not-null="true" length="20" unique="true"/>
...

<many-to-one name="firm"
class="firm"
column="firmId"
fetch="join"
update="false"
insert="false"
not-found="ignore"
not-null="false"
/>
</hibernate-mapping>


Now I would like to have a property in my DictionaryTag that maps to firm.name as if I had mapped it like this:
<property name="firmName" column="firm.name" type="string"/>

Any idea how I can achieve this?
Thx!

I finally found how to do this using a join and a subselect as follow:

<join table="Firm" inverse="true" optional="true"
subselect="select res.id, firm.name from Resource res join Firm firm on res.FirmId=firm.id">
<key column="id"/>
<property name="firmName" column="name" insert="false" update="false"/>
</join>