How to implement left join in Sequelize?

Question

Node.js

Hello I am new to node.js and sequelize. I have a query like this:

SELECT statistics_description.title, accounts_statistics.value  
FROM accounts_statistics LEFT JOIN statistics_description 
ON accounts_statistics.name = statistics_description.name

Help implement the LEFT JOIN method with sequelize. If possible, at least with a brief explanation. Thank you very much.

Answer 1

Use required: falsefor left join

AccountsStatisticsModel.findAll({
  where: { name: '$StatisticsDescriptionModel.name$' }, 
  include:[
    { 
      model: StatisticsDescriptionModel,
      attributes: ['title', 'name'],
      required: false,
    }
  ],
  attributes: ['value', 'name'],
});