Please convert this SQL Query to mongo_query

Working with Data
,
1

SELECT * FROM Orders WHERE OrderID IN
(SELECT OrderID FROM Employees WHERE EmployeeID = 5);

2

Hello @Prabhudatta_Mishra ,

Welcome to The MongoDB Community Forums! :wave:

To understand your use case better, could you please share below details:

  • MongoDB Version
  • Sample documents
  • Collections involved
  • Expected Output
  • Any queries that you have worked on?
  • What is the end result that you are trying to get from this?

Regards,
Tarun