update A
set (A.a2,A.a3) =(select B.b2,b.b3
from B
where B.b1= A.a1 and A.a3=100
)
posted on 2019-04-01 18:02 LynnChen 阅读(509) 评论(0) 编辑 收藏 举报