Field Value of Table A updated to table B

Table A field updated to table B field value T1 table structure id name school1 ming1 Tsinghua University 2 ming2 Peking University 3 ming3 Fudan University T2 table structure id student school11 ming1 Oxford University 12 ming3 Cambridge University the name of table T1 corresponds to the student value of table T2 on a 1-to-1 basis. Requirement: the values of these two fields are the same, and the school of Table A is updated based on the school of Table B. Statement: update t1 set school = (select school from t2 where name = student) where exists (select * from t2 as B where name = B. student); Result: T1 table structure id name school1 ming1 Oxford University 2 ming2 Peking University 3 ming3 Cambridge University Note: Do not add the table to be updated in the condition. PS: join query statement: select aii. update_time, pn. public_time, pn. * from t_apply_item_instance aii, t_public_notice pn where pn. apply_item_instance_uuid = aii. uuid and aii. apply_item_uuid in ('000000', '000000', '000000', '000000', '000000', '000000', '000000', '000000 ', '123', '123', '123') and aii. apply_status = 21 and pn. public_type = 1 update statement: update t_public_notice set public_time = (select aii. update_time from t_apply_item_instance aii where apply_item_instance_uuid = aii. uuid and aii. apply_item_uuid in ('000000', '000000', '000000', '000000', '000000', '000000', '000000', '000000 ', '123', '123', '123') and aii. apply_status = 21 and public_type = 1) where exists (select t1. * from t_apply_item_instance as t1 where region = t1.uuid and t1.apply _ item_uuid in ('2016', '2016', '2016 ', '123', '123', '123', '123', '123', '123', '123', '123', '123 ') and t1.apply _ status = 21 and public_type = 1) the update table does not exist in the following conditions.