SQL Server Update语句

Question

我想在表Customer set Status = 'A‘中给出一个人的值

如何查询mastersales与Customer表有关联？

属性和值MasterSales

示例公司: ABC公司(ms001)

mastersales : ms001 (primarykey)
Customer    : cu0112, cu113,cu114,cu116,cu117

mastersales : ms002 (primarykey)
Customer    : cu0115

所以我想更新customer set status = 'A‘，其中customer = mastersales ms001 (cu0112, cu113,cu114,cu116,cu117 )

Answer 1

试试这个：

UPDATE c
    SET status = 'A'
    FROM Customer c
    INNER JOIN Mastersales m ON c.customer = m.customer 
    WHERE m.mastersales = 'ms001';

Answer 2

update tablename set status = 'A' where customer in (select customer  from tablename where mastersales =ms001);