jpql相交

Question

我有四个问题，返回中间。

select listOfIntegers from [something]...

(编辑：结果是行)

需要一个方法来做

select ...
intersect
select ...
intersect
select ...
intersect
select ...

但是在jpql中并没有这样的相交。

那么，是否有一种方法可以使用其他jpql来模拟行为以获得相同的结果？

(对于那些对互斥系统不确定的人)基本上，我需要得到显示在所有选择中的所有值.

result from select 1: 1,2,3,4
result from select 2: 1,2,5,6
result from select 3: 1,2,7,8
result from select 4: 1,2,9,0

so the result i want with intersect: 1,2

很多

附注：除了JPQL :(没有本地查询等.

Answer 1

你能用这样的东西吗？

select s1.result
  from select_1 as s1
 where exists (
               select *
                 from select_2 as s2
                where s2.result = s1.result
              )
       and exists (
                   select *
                     from select_3 as s3
                    where s3.result = s1.result
                  )
       and exists (
                   select *
                     from select_4 as s4
                    where s4.result = s1.result
                  );