从两个不相关的表更新查询

I need to update a column in a table. The update value should be retrieved from another table. The query I made is statement:I need to update a column in a table. The updat