TRy this.
UPDATE e
SET e.passportcode = p.passportcode
FROM Employee e
INNER JOIN Passport p ON p.EmployeeId = e.EmployeeId
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]