I have two files:
905894 1197693 3703749
905894 Test1 1197693 Test2 3703749 Test3
I want to get the values in the second column if elements in file 1 column 1 matches any of the words in file 2 column 1.
I know awk can do it, but stuck in reading file 1 and using a loop.