Hi,

I need to do a query with Outer Join.

This is my query:


select U.id_usuario, U.dc_login, U.dc_clave, R.id_proyecto
from usuarios U, responsables R
where U.id_usuario = R.id_usuario (+) and
(id_proyecto (+)= 2 )


With Outer Join HQL I can't put the criteria (id_proyecto (+)= 2 )

How can I do this?

I try to do with Union of select but I don't know how to do UNION.

Thank you.

Unions are not possible with HQL, see:
http://www.hibernate.org/117.html#A20

Regards,

Mark