Long time listener first time poster. Hope someone can advise.

I have two files, 1000+ lines in each, two fields in each file.

After performing a sort, what is the best way to find exact matches where field $1 and $2 in file1 are also present in file2 on the same line, then output only those into file3?

Field 1 will always be unique within the files, but not field 2, there could be numerous entries of the same text.

So where field 1 and field 2 on a line in file 1, both only exist on the same line in file 2, output to file 3.

Thanks in advance.

File 1

Code:

abcdefgh    name1
bcdefgha    name2
nmrsthji    namei
nmdherya    wood
kasjfhsw    moon
pqoweiru    sun
wershgsy    other
iundhstw    tree            
gfhskwyt    mine
alskalak    hoover

File 2

Code:

abcdefgh    name1
bcdefgha    name5
hjgdrnja    namej
nmdherya    notwood
kasjfhsw    moon
wershgsy    other
pqoweiru    sun
        
 gfhskwyt    mine
alskalak    hoover

--- Post updated at 02:25 PM ---

Confusing myself.

I dont mean field 1 and field 2 on line 3 in file 1, have to be on line 3 in file 2.
But field 1 and 2 on line 3, must match in file 2, on any line, then output to file 3.

Moderator's Comments:

Please use CODE tags as required by forum rules!