50,528
社区成员
发帖
与我相关
我的任务
分享
update A,B
set A.a2=B.b2,A.a3=B.b3
where B.b1= A.a1 and A.a3=100
delete/update from t where pid in (
select temp.pid from (
select pid from t group by pid HAVING count(1)>1
) temp);
update a , b
set a.a2 = b.b2,a.a3 = b.b3
where a.a1 = b.b1
and a.a3 = 100