```
UPDATE [dbo].[DUMMY_15C_1000_2019_20]
SET [dbo].[DUMMY_15A_1000_2019_20].[TXT_DISTRIBUTION_CHANNEL_CODE] = [dbo].[DUMMY_15C_1000_2019_20].[TXT_DISTRIBUTION_CHANNEL_CODE]
FROM [dbo].[DUMMY_15C_1000_2019_20]
JOIN  [dbo].[DUMMY_15A_1000_2019_20]  
ON [dbo].[DUMMY_15A_1000_2019_20].[TXT_POLICY_NUMBER] = [dbo].[DUMMY_15C_1000_2019_20].[TXT_POLICY_NUMBER];

```

> 
> Msg 4104, Level 16, State 1, Line 7  
> 
> The multi-part identifier "dbo.DUMMY\_15A\_1000\_2019\_20.TXT\_DISTRIBUTION\_CHANNEL\_CODE" could not be bound.
> 
> 
>