Update rows from another table

This question already has an answer here:

How do I UPDATE from a SELECT in SQL Server? 27 answers

---

UPDATE  q
SET     country = a.country
FROM    quantity q
JOIN    acronym a
ON      a.acronym = q.country

链接地址: http://www.djcxy.com/p/16854.html

上一篇: Sql更新查询

下一篇: 从另一个表中更新行