如何在MongoDB中联接主明细表和主条件

db.主明细表.aggregate([
  {
    $lookup: {
      from: "主条件",
      localField: "主明细表字段",
      foreignField: "主条件字段",
      as: "联接结果"
    }
  }
])

db.主明细表.aggregate([
  {
    $lookup: {
      from: "主条件",
      localField: "主明细表字段",
      foreignField: "主条件字段",
      as: "联接结果"
    }
  },
  {
    $match: {
      // 添加筛选条件
    }
  },
  {
    $project: {
      // 添加需要的字段
    }
  }
])

db.主明细表.aggregate([
  // 聚合操作
]).toArray()