i my request hql
the join dosnt work

exemple:
"select elements(interv.actionsindividuelle) from com.cosoftware.Intervenant interv join interv.actionsindividuelle as indiv where interv.id_intervenant=1 and indiv.id_action=2 ");

thank for all suggestions.

Doesnt work is really not a sufficient description of the problem.

the problem is :

when i execute the query hql;it dosnt retrieve the right information from
the database (mysql)

don't forget what we advice you at http://forum.hibernate.org/viewtopic.php?t=930309

secondly:
When asking questions, give at least:
the Hibernate version
your mapping documents
the Java code between sessionFactory.openSession() and session.close()
the full stack trace of any exception that occurs
the name and version of the database you are using
a debug level Hibernate log excerpt is also appreciated

sorry;

i use hibernate 2.1
mysql 4.0.15

Session session = ConnectionFactory.getInstance().getSession();

try
{
query query =
session.createQuery(
"select elements(interv.actionsgroupe)
from com.cosoftware.Intervenant interv
join interv.actionsgroupe particip where
interv.id_intervenant=1 and particip.statut='