http://qs321.pair.com?node_id=1084518


in reply to Perl command line for table join functionality

It sounds rather like join is the tool that you seek ... e.g.
sort file2 > file2.sorted sort file1 | join -26 - file2.sorted
or similar ...

A user level that continues to overstate my experience :-))