Merging two files with a common column

Shell Programming and Scripting
1

Hi, I have two files file1 and file2. I have to merge the columns of those two files into file3 based on common column of two files. To be simple.

file1:

Row-id  name1

13456 Rahul 
16789 Vishal
18901 Karan

file2 :

 Row-id  place

 18901 Mumbai
 16789 Bangalore

file3:
Row-id name1 place
13456 rahul
16789 Vishal Bangalore
18901 karan Mumbai

I have to merge the two files after sorting file1 and file2 on Row-id. Please get me out of this problem. Thanks.

2

I have done some modifications to be clear on my question. Please can anyone help me on above question ? :frowning:

3

Check the "join" command.