CODEWITHSUNDEEP
javahibernatehibernate-criteria
rishi
rishi

Reputation: 1842

criteria query on entities not having joins

Is there any way to write criteria query on entities not having explicit joins ? By explicit join I mean that 2 tables in database have no foreign key relationship but some columns need to be fetched from both the tables so joins are required in query. I know that queries having join can be written with 'in' clause and criteria queries can be written with "In" criteria. I have written HQL for this case but please tell me how to write criteria query for this case.

Thanks in advance

Upvotes: 3

Views: 346

Answers (1)

Radim Köhler
Radim Köhler

Reputation: 123861

In this case, the cross join would be solution, but that is possible ONLY with HQL. Check doc (small cite):

16.2. The from clause

Multiple classes can appear, resulting in a cartesian product or "cross" join.

from Formula, Parameter

from Formula as form, Parameter as param

And, also, we can filter on any of these two Entities inside of the WHERE clause, to narrow the cartesian product...

Upvotes: 1

Related Questions