Also see join - join two files according to a common key.
In reply to Re: Merge 2 files using key field by Corion in thread Merge 2 files using key field by Jalcock501