Hi,

Is it possible to translate the next SQL to Criteria API?

select a.id, b.name, b.value

from a

left join a_b on (a_b.id_a=a.id and a_b.id_b=1)

left join b on (a_b.id_b=b.id)

I don´t know translate the condition in 'left join' ( and a_b.id_b=1)

Thank you.

this should be possible, by simply putting that extra condition in the WHERE clause.

e.g. without knowing your classes or mapping, something like (fragment only...)

session.createCriteria(A.class)
.createAlias("aBMap","a_b")
.add( Restrictions.eq("a_b.id",1) )
....

just a quick answer, you'll need to look up some stuff above, but i hope it helps...

Thank you kshih but your query it isn´t valid for me.
I want the condition is in left outer join and not in 'where' clause because
the results are very diferent

A and B are entities.
A_B is the relationship table (don´t exist mapping)

Thanks for trying

try to use