delete from tab_1 where column in ( select tab_1.column from tab_1 left join tab_2 on tab_1.column=tab_2.column where tab2.other_col like '%a%' ) 将tab1中的数据删除,这些数据符合tab2中other_col的条件