[Solved] Update…Set…From…Where query is affecting all rows and not specific ones

by


Thank you all. I needed to find the common column (the ID column).

UPDATE t
SET 
t.Address="FDAN"
FROM
TBTest.dbo.Site t
INNER JOIN Jobs j
ON t.Site_ID = j.Job_ID
WHERE j.Job_No = 'F0085'

I don’t fully understand how the aliases work. But it appears to be working fine.

13

solved Update…Set…From…Where query is affecting all rows and not specific ones