Hi,

I would like to be able to nest join elements in my mapping file so that i can select data from tables that are directly related to each other.

For example given the following table structure:

Table1
ID

Table2
ID
Table1ID

Table3
ID
Table2ID

Table4
ID
Table3ID
Data

I want to be able to use the following mapping:
<join table="Table2">
<key column="Table1Id"/>
<join table="Table3">
<key column="Table2ID" />
<join table="Table4">
<key column="Table3" />
<property name="Data" column="Data" />
</join>
</join>
</join>

The schema at the moment only seems to support having a single join in a class mapping file. Does anyone know if this is possible?

Thanks