The multi-part identifier could not be bound

[s1shoaib]

Trying to update data from one server to the server. There are 3 columns: Year, Site and Code that need to be updated from my current server to Server2, however I keep on getting the error of "The multi-part identifier could not be bound." Below is my query:



[code]UPDATE [Server2].[Fleet].[dbo].[log]

SET
[Server2].[Fleet].[dbo].[log].[Year]= Poll.[Year],
[Server2].[Fleet].[dbo].[log].[Site]= Poll.[Site],
[Server2].[Fleet].[dbo].[log].[code]= Poll.

 
 FROM(SELECT Year, 
Site, 
Code
 
 FROM sacfindb.[UC_POLog].[dbo].[ctbl.Main.Report]
 
 WHERE Year = left(convert(varchar,getdate(),126),7)
      AND Site = '7115'
      and Code in (
      '52120','52140','52147','52146','52182'
      )) Poll