22,300
社区成员




UPDATE A
SET A1 = (
SELECT Max(B1) FROM A,B WHERE B.B2=A.A2
)
update a
set a.A1=b.maxb1
from A a
left join
(select B2,max(B1) 'maxb1'
from B
group by B2) b on a.A2=b.B2
UPDATE a
SET a.A1=(SELECT Max(B1) FROM B WHERE B.B2=a.A2)
from A a
UPDATE A
SET A1 = a.B1
FROM B a
where A2 = a.B2 and not exists (select b.B1 from B b where b.B1>a.B1)