如何根据条件从另一个表更新表中的列？

I am having two tables

我有两张桌子

1. student table it contains (Student_id,school_code,name,year,...)student