Hi all,

i want to fetch data from two tables by joining three tables.

My tables association is like -

one servicer has many deals. and one deal has many loans.

I want to get all column from loan table and servicer name from servicer table.

this is done with normal hql as

select <properties> from Loan l, servicer s, deal d where
l.key = d.key1
d.key2 = s.key.

In this query <properties> contains columns from loan and servicer.

But how do i fetch same records from two tables through Criteria query.

You will have to create two alias.