join table without association

SIau_Tie · **Posted:** Thu Jul 03, 2008 9:54 pm

is there any way to create criteria for joining 2 table without association?
ex for SQL created : select student.* from student, member where student.name = member.name

Cameron McKenzie · **Posted:** Fri Jul 04, 2008 1:41 pm

You could just add a restriction:

Restrictions.sqlRestriction("***.name in (select name from member)")

Something like that.

Here's a little tutorial on using the Hibernate Critieria API from my website. You might find it helpful:

How to Use the Criteria API in you Hibernate Applications: A Simple Tutorial

sureshpw · **Joined:** Thu Jul 24, 2008 12:44 pm **Posts:** 1

Code:

Criteria criteria = session.createCriteria(Student.class);
criteria.add(Restrictions.sqlRestriction("{alias}.name in (select name from member)");

-- suresh --

DannieA · **Joined:** Fri Jul 25, 2008 1:55 am **Posts:** 1

Great!
Thanks for the info.. :)

SIau_Tie · **Posted:** Mon Aug 18, 2008 8:29 pm

Thanks for the info :)