Hi,

I would like to append a criteria in an inner join. This inner join is created in hibernate mapping and I need appending a criteria in "hard". This criteria would be test.num.type='005' on the inner join.

***********************************************

<class name="com.ngr.reposys.back.essai.model.essai" table="val" mutable="false" schema="test" >

<composite-id >
<key-property name="idPrefix" column="VLVALR" type="StringAS400UserType" />
<key-property name="idSuffix" column="VLVALS" type="StringAS400UserType" />
</composite-id>

..........

<join table="num" schema="test" optional="false" >
<key not-null="true" >
<column name="NURACI" not-null="true" />
<column name="NUGRE" not-null="true" />
</key>
<property name="isinCode" type="StringAS400UserType" />
</join>
</class>

Thanks !!!
Cyril