How do I perform the SQL Join equivalent in MongoDB?

by

As of Mongo 3.2 the answers to this question are mostly no longer correct. The new $lookup operator added to the aggregation pipeline is essentially identical to a left outer join:

https://docs.mongodb.org/master/reference/operator/aggregation/lookup/#pipe._S_lookup

From the docs:

{
   $lookup:
     {
       from: <collection to join>,
       localField: <field from the input documents>,
       foreignField: <field from the documents of the "from" collection>,
       as: <output array field>
     }
}

Of course Mongo is not a relational database, and the devs are being careful to recommend specific use cases for $lookup, but at least as of 3.2 doing join is now possible with MongoDB.

More Related Contents:

  1. Multiple join conditions using the $lookup operator
  2. How to join multiple collections with $lookup in mongodb
  3. Mongodb Join on _id field from String to ObjectId
  4. Query for documents where array size is greater than 1
  5. Mongodb $push in nested array
  6. How to select a single field for all documents in a MongoDB collection?
  7. mongodb group values by multiple fields
  8. MongoDB query multiple collections at once
  9. Conditional $sum in MongoDB
  10. mongoDB/mongoose: unique if not null
  11. arrayFilters in mongodb
  12. MongoDB password with “@” in it
  13. exclude fields in $lookup aggregation
  14. Mongo how to $lookup with DBRef
  15. Add some kind of row number to a mongodb aggregate command / pipeline
  16. How to enforce foreign keys in NoSql databases (MongoDB)?
  17. How do you query for “is not null” in Mongo?
  18. MongoDB: exception in initAndListen: 20 Attempted to create a lock file on a read-only directory: /data/db, terminating
  19. MongoDB sort documents by array elements
  20. MongoDB won’t start after server crash
  21. How does sorting with an index work in MongoDB?
  22. How to use dot in field name?
  23. How to get multiple document using array of MongoDb id?
  24. Docker: change folder where to store docker volumes
  25. How to organise a many to many relationship in MongoDB
  26. Mongodb aggregation pipeline how to limit a group push
  27. How to check if an array field contains a unique value or another array in MongoDB?
  28. How to do pagination using range queries in MongoDB?
  29. MongoDB Single Document size limit is 16MB
  30. mongodb aggregate query isn’t returning proper sum on using $sum

Leave a Comment