我是“反加入”的忠实拥护者。这对于大型和小型数据集都有效:
delete from ms_author ma where not exists ( select null from author a where ma.name = a.name )