About
Pricing
Community
Teams
Start Free Trial
Log in
tmitch1968
asked on
4/14/2015
How to combine the results of two HQL queries into one
I have two HQL queries that I need to combine into a single set of results.
Both ObjectOne and ObjectTwo are derived from the same base class. ObjectOne has
The first query is...
SELECT
//Some things
FROM
ObjectOne objectOne,
ObjectTwo objectTwo
WHERE
objectOne in elements(objectTwo.compone
nts)
And the second query is...
SELECT
//Some things
FROM
ObjectOne objectOne
LEFT OUTER JOIN objectOne.parentObject parentObj
WHERE parentObj.myField is null
Thanks in advance!
SQL
1
1
Last Comment
Naitik Gamit
8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Naitik Gamit
4/14/2015
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck