You can use a mapping load to get from one table the correct values and apply to the second table. If there are a lot of fields, this can be cumbersome... Here you are an example on how this works
MAPPING LOAD EmpID,
SQL SELECT EmpID, Name
Name AS OriginalWrongName,
ApplyMap('RightNamesMap', EmpID, Name) AS RightName;
SQL SELECT EmpID, Address, Name
The key here is the MAPPING prefix in the first table and the ApplyMap() function in the second. What this will do is to check each value of EmpID on the second table and return the value of "Name" in the first table. If the first table doesn't have the EmpID (meaning the second table has already the correct name) then the second table value of "Name" will be kept (hence the "Name" as the third parameter in the ApplyMap() function.