How to do "Join" in MongoDB

Question

I know there is the MapReduce option. However, it is rather painful. Are there any good open source tools which can enable me to use SQL-like queries to hit a MongoDB?

Thanks!

If you are trying to do a join, you're probably doing it wrong. Either you execute a second query to get related records, or you restructure the data so that the related records are a single record. — Chris Pitman, Sep 04 '14 at 21:51

sweetiewill · Answer 1 · 2014-09-05T15:57:09.907

1

The Link Here is a pretty direct SQL mapping for common queries that is quite useful and hope it helps.

edited Sep 05 '14 at 15:57

answered Sep 04 '14 at 22:02

sweetiewill

570
2
10

Thanks sweetiewill! Is there a link so I can review the SQL mapping? – user3746154 Sep 05 '14 at 14:49
I have embedded the link above just now – sweetiewill Sep 05 '14 at 15:57

How to do "Join" in MongoDB

1 Answers1