删除两个表的关联数据

delete from b where b.bid in (select aid from a where a.name = 'name');