[dba-SQLServer] UPDATE syntax with JOIN

Thanks -- that was it. 

Susan H. 

Hi Susan,

This is the syntax you require.

UPDATE    [Table1]
SET [Field] = [NewValue]
FROM [Table1] INNER JOIN [Table2] ON
[Table1].[Field] = [Table2].[Field]
WHERE [criteria]

Cheers

Michael M