Hibernate Community • View topic - How to make a join with Criteria among two "unlinked" tables

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

How to make a join with Criteria among two "unlinked" tables

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

fbcyborg

Post subject: How to make a join with Criteria among two "unlinked" tables

Posted: Thu Jan 30, 2014 9:30 am

Newbie

Joined: Thu Jan 30, 2014 9:15 am
Posts: 2

Hi,

I've read a lot of documentation but I didn't understand how to perform a join yet.

I have two tables having 1 column each:

Table1:
ID
10435562
2673958
649688
6620837
8543654

Table2:
ID
6620837
8543654

No foreign keys are present.

I want to perform the following SQL query using Hibernate Criteria:

Code:

select t1.id
from table1 t1 join table2 t2 on t1.id = t2.id;

I don't understand if I have to create some foreign key and then create Aliases to be able to do the join or not.

Could somebody explain me how to do that please?

Top

fbcyborg

Post subject: Re: How to make a join with Criteria among two "unlinked" tables

Posted: Mon Feb 03, 2014 9:14 am