Hi,

how can I do the sql query below with hibernate?

select *
from project p
right outer join project_date pd
on p.idproject = pd.idproject
right outer join date_type t
on (pd.idtype = t.idtype and pd.idproject = ?)

I looked on Creteria and SQL Query with hibernate...but I could not find a solution for this.

If anyone could point the solution or a way out of it......

tks a lot
Felipe