批量关联update

UPDATE A

SET A.field = B.field

from table A

inner join table B

ON A.field = b.field

posted @ 2019-05-10 10:44  (john_zhang)  阅读(390)  评论(0编辑  收藏  举报