update payrollexp
set Field1='FICA', Field2='Medicare', Field3='FUTA', Field8=substring(b.DivisionCode,8,2), Field4=b.Meta3, Field5=b.Meta1, Field7=b.Meta2,
annualsalary=b.JobTitleDesc
from payrollexp a
join employees b on a.EmployeeID=b.EmployeeID
update PayrollExp joining on EmpRoster Print
Modified on: Thu, 23 Aug, 2018 at 9:10 PM
Did you find it helpful? Yes No
Send feedbackSorry we couldn't be helpful. Help us improve this article with your feedback.