mongodb多表查询(附带pymongo实例)

db.orders.aggregate([
 {
 $lookup:
 {
  from: "inventory",
  localField: "item",
  foreignField: "sku",
  as: "inventory_docs"
 }
 }
])

from pymongo import MongoClient

def test():
    client = MongoClient()
    db = client[db_name]
    db[‘orders‘].aggregate([{‘$lookup‘:{‘from‘: "inventory", "localField": "item", "foreignField": "sku", "as": "inventory_docs"}}])