nodejs sequelize 的问题问个问题？这种可以用 include 来实现？

V2EX = way to explore

V2EX 是一个关于分享和探索的地方

For Existing Member Sign In

This topic created in 2359 days ago, the information mentioned may be changed or developed.

SELECT 
users.id,SUM(b)
FROM 
users LEFT JOIN c 
on c.d like CONCAT(users.d,'%')
GROUP BY users.id

4 replies • 2019-11-14 20:53:21 +08:00

zbinlin

Nov 14, 2019

应该没问题

wangyzj

Nov 14, 2019

可以

sys234

Nov 14, 2019

```javascript
//tableName=>Model
//users=>Users; c=>ModelC

Users.findAll({
attributes: ["id", [fn("SUM", col("b")), "aliasB"]],
include: [{
association: Users.belongsTo(ModelC, {
foreignKey: "d"
}),
model: ModelC,
attributes: [],
required: false,
on: {
d: {
[Op.like]: fn("concat", literal("users.d"), "%")
}
}
}],
group: [literal("users.id")],
limit: 10
}).then(result => {
console.log(JSON.stringify(result));
}).catch(err => { });
```

hua123s

Nov 14, 2019 via iPhone

@sys234 emoji，是我太愚蠢了

nodejs sequelize 的问题 问个问题？这种可以用 include 来实现？

nodejs sequelize 的问题问个问题？这种可以用 include 来实现？