How to join two collections in mongo Db?

Question

I've created two collections one for people details and another for their income, spending amount etc.

i want cumulative result how to combine both collections??

Hi Sudharsana Viswanathan; can you [edit] your question to show what you have tried so far? — Vince Bowdren, Mar 19 '17 at 19:06

score 2 · Accepted Answer · answered Mar 19 '17 at 17:33

2

You can insert all documents from one collection into another. Here is how to do that using the mongo shell:

db.collection1.find().forEach( function(x){db.collection2.insert(x)} );

answered Mar 19 '17 at 17:33

Joseph Milane

184
1
9

score 0 · Answer 2 · edited May 23 '17 at 12:10

0

Instead of combining them into one collection (which may or may not be correct in your situation - no way of knowing) take a look at this StackOverflow. Also you should seriously study both the lookup and aggregation possibilities in MongoDB. Since Mongo is NoSQL the way we approach lookup information is a bit different.

edited May 23 '17 at 12:10

Community

1
1

answered Mar 20 '17 at 05:15

twg

1,075
7
11

How to join two collections in mongo Db?

2 Answers2