node.js - nodejs sequelize join query -

suppose have 2 models

var = db.seq.define('a',{     id1: { type: db.sequelize.integer},     id2: { type: db.sequelize.integer},     count: { type: db.sequelize.integer}, });  var b = db.seq.define("b",{     id1: { type: db.sequelize.integer },     id2: { type: db.sequelize.integer },     name: { type: db.sequelize.string}, });  a.hasmany(b, {foreignkey: 'id1'}) b.belongsto(a, {foreignkey: 'id1'})  a.findall({     include: [{         model: b,         where: { b.id2: { $eq:a.id2 } }     }] }) 

its possible make kind of query?

how can update model specify other condition on join sentence or should move check query clause?

some example helpful

thanks

try

a.findall({     include: [{         model: b,         where: { id2: sequelize.col('a.id2') }     }] }) 

id2 automatically reference b.