sql server - 从另一个表更新数据

My problem is:

我的问题是：

I have 2 tables Assignment and Services I am trying to update one column from another table's column's data like that.

我有2个表分配和服务我试图从另一个表的列的数据更新一列。

UPDATE [Services]
SET
      TeamID = (SELECT [AssignedTeam]
                       FROM [Assignment]
                       WHERE [ServiceName] in ([Services].[ServiceName]))
WHERE
    EXISTS (
        SELECT [ServiceName]
        FROM [Assignment])

it does not work. can someone help me about that situation please? Thx

这是行不通的。有人可以帮我解决这个问题吗？谢谢

2 个解决方案

#1

Update using JOIN.

使用JOIN更新。

Query

询问

UPDATE t1
SET t1.[TeamID] = t2.[AssignedTeam]
FROM [Services] t1
JOIN [Assignment] t2
ON t1.[ServiceName] = t2.[ServiceName];

#2

UPDATE [Services] SET TeamID = [AssignedTeam] FROM [Assignment] WHERE [Assignment].[ServiceName] = [Services].[ServiceName]