Hello everywhere!
How do I make a join with multiple conditions?
Example:
************
Model1
Model2
***********
Model1.belongsTo(Model2);
Model1.findAll({
attributes: ['id'],
include: [{
model: Model2
where: {
number: Model1.number =>>>>>>>>>>>>>>>>>> ¿:c?
}
}],
where: {
state: true
}
})
I want this:
Select id From Model1 inner join Model2
On Model1.id = Model2.id
AND Model1.number = Model2.number
:c
Help me, please!
thank you!