MongoDB Left Anti-Join
Suppose you have two Collections (A and B) in a MongoDB Database, and you want to find all Documents in A whose certain field does not exist in any of the Documents in B. In SQL, you would use some thing like this:
SELECT *
FROM A
WHERE NOT EXISTS ( SELECT…