Hi,
I want to perform a "left outer join" on two tables, specifying join conditions.

Ex:
TableA(col1A, col2A)
TableB(col1B, col2B)

select * from TableA ta left outer join TableB tb on (ta.col1A=tb.col1B and ta.col2A=tb.col2B);

Any idea, how can I achieve the same using hibernate criteria.

Using this, it is doing left outer join on the foreign/primary keys..

session.createCriteria(TableA.class, “tableAAlias”)
criteria.createAlias(TableB, “tableBAlias”, Criteria.LEFT_JOIN);

I didn’t find any way to add join conditions..

--
Thank you,
B. Palvali Teja.