For the below query
SQL:
SELECT * FROM TableA as A LEFT JOIN TableB as B ON (A.id = B.id AND A.name =B.name)
Mongo:
TableA.aggregate([
{"$lookup": {
"from": "TableB",
"localField": "_id",
"foreignField": "_id",
"as": "b"
}},
{ "$match": { "name":"b.name" } }
])
For the above query, required output is not coming.
You could refer this sample playground
db.orders.aggregate([
{
"$lookup": {
from: "inventory",
let: {
id: "$_id",
item: "$item"
},
pipeline: [
{
"$match": {
$expr: {
"$eq": [
"$_id",
"$$id"
],
"$eq": [
"$sku",
"$$item"
]
}
}
}
],
as: "outputs"
}
}
])
Collected from the Internet
Please contact [email protected] to delete if infringement.
Comments