Dear friends,

I have two files. In first file first column ($1), i have numbers.

The second file containes, the same number in the fourth column($4).

I need a output file, matching the first file column 1 with second file column 4. The main thing is the output file lines will be sorted without changing the line.


Eg:

File1:
123
124
125

File 2:

we are at 123 from unix
we are at 124 from linux
we are at 123 at script
we are at 567 at perl
we are at 125 at awk

Desired Output:
we are at 123 from unix
we are at 123 at script
we are at 124 from linux
we are at 125 at awk