I have to inner join below collection with multiple conditions cards: id, name, status, card_emotions: id, card_id, user_id,text common field: id and card_id ( foreign field of cards [ id ] select * from cards c on inner join card_emotions cm on c.id = cm.card_id where c.status = ' ACTIVE' AND cm.user_id = 13
Please provide sample documents we can play with in our environment.
Also provide sample resulting documents.
Share what you have tried so far and indicate where it fails so that we do not orient ourselves in the same direction.
Did you figure out the inner join query in MongoDB? Am looking for the same.