问题在UPDATE语句中使用JOIN [英] Problem Using JOIN in UPDATE Statement

问题描述

我有两个表，我想更新一个表的值，其中值在第二个表中。

我想在一个查询中使用它。我试过两个查询，比如先选择记录，然后更新，

但我想在一个查询中。

i am having two tables, i want to update value of one table where value is in second table.
I want it in one query. i have tried with two query like first to select the record and then update,
but i want in one query.

Emp_Table
Empid JobId	ManagerId

Job_Table
JobId	Designation

想要更新员工的工作加入两张桌子。请帮助

want to update job of employees by joining two tables. please help

推荐答案

您可以加入两个表，尝试以下示例：

You can join two tables, try following example:

UPDATE Join1 SET Col2 = t2.Col2,
Col3 = t2.Col3
FROM Join1 t1
INNER JOIN Join2 t2 ON t1.Col1 = t2.Col1
WHERE t1.Col1 IN (1,2,3) -- your filter can be placed here
GO

在你的牌桌上尝试同样的事情。

try same thing on your tables.

这篇关于问题在UPDATE语句中使用JOIN的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！