删除重复记录

delete a--用别名 from #ta a where exists (select 1 from #tb b where a.id=b.id)
delete #ta --用别名 from #ta a where exists (select 1 from #tb b where a.id=b.id)