SELECT *
FROM A
INNER JOIN B
ON A.temp LIKE B.temp
查询的时候加一个 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);
});