How to convert this piece of sql code to oledb command?

[GaryMazzone]

UPDATE S SET
     S.empnum = ER.Employee_Number
FROM scard S
INNER JOIN Employee_Records ER
   ON s.FirstName = ER.First_Name

BUT What happens when you have 2 people with the same first NAME (John) then you really don't know what you get in the end