Avatar of tmitch1968
tmitch1968
 asked on

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.components)
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

Avatar of undefined
Last Comment
Naitik Gamit

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Naitik Gamit

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