data:
exports.findAll = function *(query) {
let where = {};
if (query.sodHStoreId && query.sodHStoreId != '') where.sodHStoreId = query.sodHStoreId
let page = yield db.sequelize.Sod.findAndCountAll({
attributes: {exclude: ['createdAt', 'updatedAt']},
where: where,
include: [
{model: db.sequelize.Shop, as: 'hshop', attributes: ['store_id']},
{model: db.sequelize.Sct, as: 'scts', attributes: ['sctid','sctstoreuserid','sctcontents','sctcreatetime','sctstoreuserid',],
include:{model: db.sequelize.StoreUser, as: 'storeuser', attributes: ['store_user_id','store_user_name']}}
],
order: [['sodid', 'ASC']]
})
return page;
}
Sequelize关联查询是左连接,我想要内连接怎么做
- 写回答
- 好问题 0 提建议
- 追加酬金
- 关注问题
- 邀请回答
-