Sequelize join query with condition
Put the where filter for the users table in the include section:
models.account.findAll({
attributes: ['password'],
include: [{
model: models.user,
where: {
email: email
}
}],
where: {
password: password
}
}).then(function(res){
console.log(res);
});