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

This topic created in 2546 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

users

select

concat

Sequelize

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 来实现？