Shell Programming and Scripting

I have file 1 & file 2 with content mentioned below. I want to get the output as shown in file3.
Requirement:
check the content of column 1 & column 2, if value of column 1 in file1 matches with first column of file2 then remaining columns(2&3) of file2 should get replaced, also if value of column 2 in file1 matches with first column of file2 then remaining columns(2&3) of file2 should get replaced with comma separater.

Please help as i am new in shell scripting

file 1:

Code:

100 919136006473 16a1
200 919810012345 9191365555559

file 2:

Code:

919136006473 MTS Del
16a1 TATA PB
919810012345 ID HR
9191365555559 AIR KT

file3

Code:

100, MTS Del,TATA PB
200,ID HR,AIR KT

What have you tried so far and where are you stuck? What happens when there are no matches on a line? No commas then?

i am not sure how to use awk for matching col1/col2 from file1 simultaneously & then replace the same with value of the same from file2 I am able to print using but parsing the complete file is an issue & then matching/replacing with file2 is not happening. NO IDEA HOW IT WILL HAPPEN & TOTALLY CONFUSED.
Please help

Your solution would need to be processing two files, you could do that using awk. There are many examples like that with the NR==FNR construct. You could first build an index (say using an array "A") with the entries from file 2 (column1 is the index, column 2 the value). Then when processing file 1 you can first look at field 2 and then at field 3 and if they are present in array "A" then replace them with that vaiue ($2=A[$2]). OFS can be used to change the output field separator to a comma.

Would that help you?

On top of what scrutinizer says, your specification does not fit what you present as an output from your input files. Please rephrase carefully!