Read the data from the second file into a hash ($hash{$firstcolumn} = $thirdcolumn).  Then go through the first file line by line, split the columns and replace the second column with $hash{$secondcolumn} before you join and print the line out again.