Update column value from one table to another table

update TPD
Set TPD.ID=TSL.RId
from UpdateTableName as TPD
INNER JOIN GetDataTableName as TSL on TSL.SourceMessage=TPD.SourceMessage
where TPD.ID is null