如果T2有个不重复的UID什么的就可以用如下语句:
delete from T2 where UID in(select a.UID from T2 a with(nolock) full join T1 b on a.name=b.name and a.time=b.time)
delete from T2 where UID in(select a.UID from T2 a with(nolock) full join T1 b on a.name=b.name and a.time=b.time)
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货