求解sequelize mysql怎么实现以下查询？

Question

SELECT * 
FROM A
INNER JOIN B
ON A.temp LIKE B.temp

Answer 1

查询的时候加一个 required: true 参数即可，详情参见：http://docs.sequelizejs.com/en/latest/api/model/

在浏览器中打开上述网址，你可以 Ctrl + F 查找 INNER JOIN 即可看到你想要的配置，下面是我写的Demo，献丑了。

// Demo
var A = sequelize.define('A', {
    id: { type: Sequelize.INTEGER, autoIncrement: true, primaryKey: true, unique: true },
    num: { type: Sequelize.STRING }
}, {
    tableName: 'a'
});


var B = sequelize.define('B', {
    id: { type: Sequelize.INTEGER, autoIncrement: true, primaryKey: true, unique: true },
    num: { type: Sequelize.STRING }
}, {
    tableName: 'b'
});


A.hasMany(B, {
    foreignKey: 'id'
});

B.belongsTo(A, {
    foreignKey: 'id'
});

A.findAll({
    include: {
        model: B,
        required: true // 加个required: true,即可
    }
}).then(function (results) {
    console.log(results);
});