Update a table with data from another table
You can use next syntax:

update tbl1
join   tbl2
on     tbl1.user_id = tbl2.user_login
set    tbl1.contact_email = tbl2.user_email;





select * from tbl1;



user_id | contact_email  | contact_name
------: | :------------- | :-----------
    123 | test@test.com  | deft        
    124 | test3@test.com | deft3       



dbfiddle here