SQL update inner join not working in SQL Server?

Question

UPDATE  d
set d.tSynchronized = 1
from TImageRaw d
inner join TPatientRaw f
on f.tPatCulIntPatIDPk = d.tImgCulIntPatIDFk

The code above is not work in SQL Server, can someone point me the right direction ?

Answer 1

Your UPDATE structure looks fine at first glance. Since you have not stated the error, here are some probable causes:

• You misspelled some table name
• You misspelled some column name
• f.tPatCulIntPatIDPk and d.tImgCulIntPatIDFk do not have compatible types
• d.tSynchronized is not a numeric typed field