SQL Server更新查询更新两个表

I am using SQL Server. I have written an update statement using a join. I try to update one column in the table, but my update statement removes the value from another table. I do not understand why it is happening even though I am updating value for one column.I am using SQL Server. I have written an update