title: inner join using mongo query (pymongo)
body: <p>I am new to SQL query and first time working with MongoDB using Pymongo.</p>
  <p>I have two collections in MongoDB.</p>
  <pre><code>DEPARTMENT
  
  dept_id   dept_name   status    location     
  ------------------------------------------
  123       sales       active     New York
  248       IT          inactive   Vermont
  845       HR          active     LA
  
  EMPLOYEE
  
  dept_id   emp_name   emp_salary  emp_status  emp_id
  ----------------------------------------------------
  123       John       25000       active      xyz
  845       Mary       90000       active      abc
  248       Kevin      50000       inactive    qrs
  
  query 1
  
  select * from DEPARTMENT where dept_id=123 and status='active'
  
  query 2
  
  select emp_name, emp_id from EMPLOYEE where dept_id =123 and status = 'active'
  </code></pre>
  <p>i want to inner join these 2 query and return all matching record and give all details from DEPARTMENT table and emp_name, emp_id from EMPLOYEE table.</p>
  <p>how will i achieve it using pymongo and sql query.</p>
  <p>Any help will be greatly appreciated!</p>
  <p>Thanks in advance!</p>