Mongoose Inner Join
<p>user collection</p>

<pre><code>user : {
"_id" : md5random,
"nickname" : "j1",
"name" : "jany"
}
user : {
"_id" : md5random,
 "nickname" : "j2",
"name" : "jenneffer"
}
</code></pre>

<p>friendship collection</p>

<pre><code>friendship : {
  "_id"  : md5rand,
  "nick1" : "j1",
  "nick2"  : "j2",
  "adTime" : date
}
</code></pre>

<p>for example SQL </p>

<pre><code>SELECT friendship.adTime, user.name 
         FROM friendship
INNER JOIN user  ON 
        (user.nickname=friendship.nick1 or user.nickname=friendship.nick2)
</code></pre>

<p>Is there any way in the MONGO to get this SQL result?</p>

<p>I WANT GET RESULTS, i know mongo not supporting this request.
But what is this better solution? Any body can write an exeample for me?</p>