in reply to Merge 2 files using key field

Also see join - join two files according to a common key.