How to write equivalent mongodb pipleline, same as below sql

Working with Data
1 
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
2

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.

3

Hi @Sarang_Patel
Did you figure out the inner join query in MongoDB? Am looking for the same.