It's hard to help you without example inputs and expected output, so I can just give you some vague directions.

It might work by reading the second file into a hash first, and then going through each row of the first file and print it to the third file, augmented with the information from the hash.

Or phrased differently, you probably need just one hash, not two.