在SQL中，如何通过查找列相等的所有行来更新表的每一行，然后将另一列设置为等于另一列

So basically this would be the psuedo code, but I don't know how to do this in SQL, please help.So basically this would be the psuedo code, but