update A set (A.a2,A.a3) =(select B.b2,b.b3 from B where B.b1= A.a1 and A.a3=100 ) 转载于:https://www.cnblogs.com/LynnChen/p/10637942.html