update a table from other table sql server

update Employee set email = lgfl.xx_email
from DB2.dbo.directEmployee lgfl join Employee on Employee.emp_name = lgfl.emp_name
where Employee.emp_id = dept.emp_id