在sequelize中使用三个表进行内部联接

Question

我尝试关联

Currency_Info.hasMany(DEAL_INFO, {foreignKey: 'selling_CURRENCY'})
COUNTERPARTY_INFO.hasMany(DEAL_INFO, {foreignKey: 'COUNTER_PARTY_CODE'})
DEAL_INFO.belongsTo(Currency_Info, {foreignKey: 'selling_CURRENCY', targetKey: 'Ccy_Code'})
DEAL_INFO.belongsTo(COUNTERPARTY_INFO, {foreignKey: 'COUNTER_PARTY_CODE', targetKey: 'COUNTERPARTY_CODE'})

var conCursor = await DEAL_INFO
.findAll({

include: [{model: COUNTERPARTY_INFO, required: true ,model: Currency_Info, required: true }]

}) 
.catch((error) => {
console.log(error.toString());
res.status(400).send("-1" + error)
})

但没有得到想要的结果

(DEAL_INFO.selling_CURRENCY=CURRENCY.CCY_CODE(上的内部联接CURRENCY

如何获得两个内部联接1.内部联接CURRENCY on(DEAL_INFO.selling_CURRENCY=CURRENCY.CCY_CODE(2.内部加入(deal_info.counter_party_code=countersarty_info.countersarty_code(上的countersart_info

Answer 1

您可以在include中使用型号列表

类似这样的东西：

var conCursor = await DEAL_INFO.findAll({
include: [
{model: COUNTERPARTY_INFO, required: true} ,
{model: Currency_Info, required: true }
]
}) 
.catch((error) => {
console.log(error.toString());
res.status(400).send("-1" + error)
})

希望你得到答案！