Thanks for the tip - I did manage to find out why it did not work, I needed to use an additional "WHERE" qualifier.

I also agree with the alias suggestion,...

Hi there, I am also trying to do something like this, but keep getting an error 42000.

My query looks like this:

UPDATE dbo.BlogCopy_copy

SET dbo.BlogCopy_copy.ProcID = dbo.BlogProcedures.ProcID

FROM dbo.BlogCopy_copy, dbo.BlogProcedures

Where dbo.BlogWebs_copy.WebID=dbo.BlogProcedures.WebID

The actual error...