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

[hua123s]

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

[zbinlin]

应该没问题

[wangyzj]

可以

[sys234]

```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]

@sys234 emoji，是我太愚蠢了