join command example

To combine two files by a common field use join command:

$ cat nms.txt 
E001 Robert Norton
E002 Ted Yelsky
E003 Chris Smith
E004 Anna Brown
E005 Brian Martin

$ cat depph.txt 
E001 843-677-1367
E002 831-936-5892
E003 854-849-4294
E004 884-973-9674
E005 899-055-4203

$ join nms.txt depph.txt 
E001 Robert Norton 843-677-1367
E002 Ted Yelsky 831-936-5892
E003 Chris Smith 854-849-4294
E004 Anna Brown 884-973-9674
E005 Brian Martin 899-055-4203