how to make manual refreces, or inner joins in mongodb using java query

[Navneet Mathpal]

Hi,

As we make inner joins in sql , primary id of one table is refrence id of another table
ex:-
SELECT Orders.OrderID, Customers.CustomerName, Orders.OrderDate
FROM Orders
INNER JOIN Customers
ON Orders.CustomerID=Customers.CustomerID;

so we can combine the result of two tables.
now I am using spring frame work and mongo db as my data base, how can i implement join in mongodb.

Happy coding
Navneet Mathpal

[Russell Bateman]

Navneet,

Welcome to the wonderful world of MongoDB. Keep your former database experience and understanding, but leave your SQL preconceptions at the door. You can't perform joins between collections (tables) in that way in MongoDB. You need to rethink what you're trying to do a little bit. Here's a link to get started:

http://docs.mongodb.org/manual/reference/sql-comparison/

As you have specific questions on your many-to-one, one-to-many, etc. relationships, come back and ask in this forum.

Hope this helps.

--
--
You received this message because you are subscribed to the Google
Groups "mongodb-user" group.
To post to this group, send email to mongod...@googlegroups.com
To unsubscribe from this group, send email to
mongodb-user...@googlegroups.com
See also the IRC channel -- freenode.net#mongodb

---
You received this message because you are subscribed to the Google Groups "mongodb-user" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mongodb-user...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Navneet Mathpal]

Hi Russell,

        can you help me in this.

https://groups.google.com/forum/#!topic/mongodb-user/gHESwfhLwds

 

[Russell Bateman]

This is in reference to your other post in this forum dealing with comparing time and date in Java as retrieved in documents from MongoDB? I would advise you to be patient; someone will surely answer. Another possibility would be to repost in stackoverflow.com.

Russ

--

[William Zola]

Hi Navneet!

In MongoDB, you need to perform application-level joins: the database cluster will not do it for you.  

This is pretty straightforward: see here for an example:

 - https://groups.google.com/d/msg/mongodb-user/p-l5vKigpRw/PYOz5myhAZEJ

 -William