How can solve sequelize mysql implement the following query?

  node.js, question
SELECT *
 FROM A
 INNER JOIN B
 ON A.temp LIKE B.temp

Add one when queryingrequired: trueParameters are sufficient, see for details:http://docs.sequelizejs.com/en/latest/api/model/

Open the above website in the browser, you canCtrl+fseekINNER JOINYou can see the configuration you want. The following is my Demo. It’s a show.

// Demo
 var A = sequelize.define('A', {
 id: { type: Sequelize.INTEGER, autoIncrement: true, primaryKey: true, unique: true },
 num: { type: Sequelize.STRING }
 }, {
 tableName: 'a'
 });
 
 
 var B = sequelize.define('B', {
 id: { type: Sequelize.INTEGER, autoIncrement: true, primaryKey: true, unique: true },
 num: { type: Sequelize.STRING }
 }, {
 tableName: 'b'
 });
 
 
 A.hasMany(B, {
 foreignKey: 'id'
 });
 
 B.belongsTo(A, {
 foreignKey: 'id'
 });
 
 A.findAll({
 include: {
 model: B,
 Required: true // just add required: true
 bracket
 }).then(function (results) {
 console.log(results);
 });