using sequelize.col for inner join queries code example
Example: sequelize left join attributes
Users.findAll({
include: [
{
model: Role,
as: 'roles',
attributes: ['columnNameToInclude']
}
]
});