Updating a column in 1 table with value from another column in another table

Question

Updating a column in 1 table with value from another column in another table

Why the following code doesn't work?

UPDATE TableX INNER JOIN TableY ON TableX.UserID = TableY.UserID
SET TableX.DepartmentID = [tabley].[departmentID];

 

Answer 1

Try :

UPDATE TableX 
SET TableX.DepartmentID = Y.[departmentID]
From TableX X
INNER JOIN TableY Y ON X.UserID = Y.UserID 

 

 

---

Best regards

Answer 2

UPDATE X

SET X.DepartmentID = Y.DepartmentID

FROM

TableX X

INNER JOIN 

TableY Y

ON

X.UserID = Y.UserID

---

Thanks, Cool Mind -- If you find my answer helpful, please mark it as Answer.