db={"items":[{"id":"111","name":"apple","status":"active"},{"id":"222","name":"banana","status":"active"}],"inventory":[{"item_id":"111","qty":3,"branch":"main"},{"item_id":"222","qty":3}]}

db.items.aggregate([{$match:{$and:[{"status":"active"},{"name":{$exists:true}}]}},{$lookup:{as:"info",from:"inventory",let:{fruitId:"$id"},pipeline:[{$match:{$and:[{$expr:{$eq:["$item_id","$$fruitId"]}},{"branch":{$eq:"main"}},{"branch":{$exists:true}}]}}]}},{"$match":{"info":{"$ne":[]}}}])