[{"_id":"C1","CUSTOMER":{"customerId":"C1","customerName":"Tony","SHOPPINGCART":[{"cartId":"cart001","purchased":"no","containsProdList":[{"prodListId":1,"productId":"P2","quantity":2},{"prodListId":2,"productId":"P1","quantity":1}]},{"cartId":"cart002","purchased":"yes","containsProdList":[{"prodListId":1,"productId":"P2","quantity":3}]},{"cartId":"cart006","purchased":"yes","containsProdList":[{"prodListId":1,"productId":"P3","quantity":3}]}]}},{"_id":"C2","CUSTOMER":{"customerId":"C2","customerName":"James","SHOPPINGCART":[{"cartId":"cart003","purchased":"yes","containsProdList":[{"prodListId":1,"productId":"P4","quantity":2},{"prodListId":2,"productId":"P3","quantity":1}]},{"cartId":"cart004","purchased":"no","containsProdList":[{"prodListId":1,"productId":"P1","quantity":3}]},{"cartId":"cart005","purchased":"no","containsProdList":[{"prodListId":1,"productId":"P5","quantity":1}]}]}}]

db.collection.find({$and:[{"CUSTOMER.SHOPPINGCART.containsProdList.productId":"P1"},{"CUSTOMER.SHOPPINGCART.containsProdList.productId":"P2"}]})