How to convert such sql query to mongodb query

Question

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:

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?

vivek mishra · Accepted Answer · 2012-03-21 09:50:06Z

2

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

answered Mar 21, 2012 at 9:50

vivek mishra

1,1628 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Does it really will be converted to one mongoDb query ?