UPDATE
t2 b
INNER JOIN t1 a
ON a.custno = b.custno
SET b.atm = a.atm
WHERE a.atm > b.atm;
https://blog.csdn.net/netuser1937/article/details/121146827
UPDATE
t2 b
INNER JOIN t1 a
ON a.custno = b.custno
SET b.atm = a.atm
WHERE a.atm > b.atm;
https://blog.csdn.net/netuser1937/article/details/121146827