sql server 联表查询删除相关数据

delete a from tb_a a
inner join
(
	select i.id from tb_a i
	inner join tb_b  b on i.id = b.id 
) c on a.id=c.id