Join return an empty array

Please provide sample documents from the source collections.

Please provide expected results.

Please provide the pipeline you have tried.

As for

you may be able to create a view from the pipeline and then lookup on the view. See https://docs.mongodb.com/manual/core/views/

1 Like