MongoDB多表查询

2022-03-16  本文已影响0人  晒雨LL

1. $lookup

db.Article.aggregate([
    {
        $lookup: {
            from: "Category",
            as: "Category",
            localField: "CategoryId",
            foreignField: "_id"
        }
    }
])

2. 嵌套语句

db.Article.find({
    CategoryId: {
        $in: db.Category.find().toArray().map(x => x._id)
    }
})
上一篇 下一篇

猜你喜欢

热点阅读