1. left join (相對于base_admin)

• sql:

select * 
  from author
  left join book
    on book.authorId = author.id

• sequelize-typescript:

    let options = {
        raw:true,
        include:[{
            model:book
        }]
    }
    
    author.findAndCountAll(options).then(results => {
        console.log("results.rows:",results.rows)
    })

2. ringt join(相對于base_admin)

備注：就是left join 的反過來查詢

• sql:

select * 
  from book
  left join author
    on author.bookId = book.id

• sequelize-typescript:

    let options = {
        raw:true,
        include:[{
            model:author,
            where:{
                id:{
                    [Sequelize.Op.ne]:null //過濾掉無效的數(shù)據(jù) 
                }
            }
        }]
    }
    
    book.findAndCountAll(options).then(results => {
        console.log("results.rows:",results.rows)
    })