Shell Programming and Scripting

Is it possible to add a new column in a file by matching a key element in second file ?

File 1
2 a
3 b
4 d
5 g
6 j
7 m


File 2

4 hjjjj
5 aaa
6 sasa
7 dsds
2 dsdf
3 fdsfg


we need to add 2nd coulmn of first file as the new column in second file by matching the first columns in both files. (First Column is like a foreign key in the case of databases)

Output File

4 hjjjj d
5 aaa g
6 sasa j
7 dsds m
2 dsdf a
3 fdsfg b

Please help in this regard.

Sort the files:

Code:

sort file1.txt > file1.new.txt
sort file2.txt > file2.new.txt

Then use "join":

Code:

join file2.new.txt file1.new.txt

Output:

Code:

2 dsdf a
3 fdsfg b
4 hjjjj d
5 aaa g
6 sasa j
7 dsds m

Thank you so much Glenn...
Came to know about join from you