update A set A.COLUMN2=(select distinct(B.COLUMN2) from B where B.ID=A.ID );
转载于:https://www.cnblogs.com/hanje/p/10636176.html
update A set A.COLUMN2=(select distinct(B.COLUMN2) from B where B.ID=A.ID );
转载于:https://www.cnblogs.com/hanje/p/10636176.html