如何将这样的sql查询转换为mongodb查询

I need to execute such sql query on mongo(I mean mongodb query should be logically equal to the sql). So here is the SQL query:

我需要在mongo上执行这样的sql查询(我的意思是mongodb查询应该在逻辑上等于sql)。所以这是SQL查询:

SELECT * FROM table1 ALIAS1
WHERE 
 field1=1
AND
 field2=2
AND (
  EXISTS(
    SELECT * FROM table2 
    where table2.field33 = ALIAS1.field1
  )
)

Is it possible to do such a query in mongodb in one query?

是否可以在一个查询中在mongodb中执行此类查询?

1 个解决方案

#1

Use https://github.com/impetus-opensource/Kundera for any such sql like queries. it allows a way to execute JPA queries over mongoDB

使用https://github.com/impetus-opensource/Kundera进行任何类似sql的查询。它允许通过mongoDB执行JPA查询的方法