title: Mongoose Inner Join
body: <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>