In SQL, how does one use columns in one table to update columns in another table?

I have two tables, all of which are mobile phone numbers. Table A contains Table B. The col001 columns of both tables are mobile phone numbers,

Table B of column col002 is a number and table A is 0. To compare the two tables, as long as the mobile phone number of Table B in Table A is used,

Then, the number corresponding to col002 in Table B is automatically updated to col002 in table A. How can we use update to implement this?

 

 

Update aset A. col002 = B. col002from bwhere A. col001 in (select col001 from B) or update aset A. col002 = B. col002from bwhere A. col001 = B. col001