UPDATE e
SET e.passportcode = p.passportcode
FROM Employee e
	INNER JOIN Passport p ON p.EmployeeId = e.EmployeeId  

UPDATE Employee
SET passportcocde =
(
    SELECT P.passportcode
    FROM Passport P
    WHERE P.EmployeeId = Employee.EmployeeId
)
WHERE EXISTS
(
    SELECT *
    FROM Passport P1
    WHERE P1.EmployeeId = Employee.EmployeeId
)