scard and Employee_Records are tables
empnum and FirstName(field/column of scard)
Employee_Number and First_Name(field/column of Employee_Records)



Code:
UPDATE scard INNER JOIN Employee_Records
    ON scard.FirstName = Employee_Records.First_Name
SET scard.empnum = Employee_Records.Employee_Number