Hibernate version: 2.1

Mapping documents:
Mapping file for table "Equipement"
<hibernate-mapping>
<class
name="com.carl.xnet.common.bean.EquipementBean"
table="Equipement"
dynamic-update="false"
dynamic-insert="false"
>

<id
name="id"
column="ID"
type="java.lang.String"
>
<generator class="assigned">
</generator>
</id>

<version
name="serial"
type="long"
column="serial"
/>

<property
name="label"
type="java.lang.String"
update="true"
insert="true"
column="label"
/>

<set
name="symptomes"
table="Equipement_Symptome"
lazy="false"
inverse="false"
cascade="none"
sort="unsorted"
>

<key
column="eq_id"
/>

<many-to-many
class="com.carl.xnet.common.bean.SymptomeBean"
column="symptome_id"
outer-join="auto"
/>

</set>

<property
name="code"
type="java.lang.String"
update="true"
insert="true"
column="code"
/>

<property
name="codePersonnalisation"
type="java.lang.String"
update="true"
insert="true"
column="codePersonnalisation"
/>

<property
name="secuPolicy"
type="java.lang.String"
update="true"
insert="true"
column="secuPolicy"
/>


</class>

</hibernate-mapping>

Mapping file for table "Symptome"
<hibernate-mapping>
<class
name="com.carl.xnet.common.bean.SymptomeBean"
table="SYMPTOME"
dynamic-update="false"
dynamic-insert="false"
>

<id
name="id"
column="ID"
type="java.lang.String"
>
<generator class="assigned">
</generator>
</id>

<version
name="serial"
type="long"
column="serial"
/>

<property
name="libelle"
type="java.lang.String"
update="true"
insert="true"
column="libelle"
/>

<property
name="codePersonnalisation"
type="java.lang.String"
update="true"
insert="true"
column="codePersonnalisation"
/>

<property
name="secuPolicy"
type="java.lang.String"
update="true"
insert="true"
column="secuPolicy"
/>
</class>

</hibernate-mapping>




Name and version of the database you are using: HSQL

Hi,
this is my HQL syntax :

SELECT elements(o.symptomes)
FROM equipement as o
WHERE o.code='TEST'

i would like that the result list only have symptome occurences which id correspond to a filter.
i don't know how to make a filter to the list :(