sql - sql minus的jpa 2.0标准api表达式

Question

如何创建等价于sql minus语句的jpa Criteria表达式

例子

  SELECT mod_code
  FROM SRS.Table1
MINUS
  SELECT mod_code
  FROM SRS.Table2;

Answer 1

负号不存在，但你可以这样做:

select t1.mod_code from Table1 t1 where not exists 
(select t2 from table2 t2 where t2.mode_code = t1.mode_code)