根据B表更新A表

Update A SET A.dept =B.name
FROM A LEFT JOIN B ON B.ID=A.dept_ID

posted @ 2013-06-04 12:06 呓语阅读(216) 评论(0) 收藏举报