Can someone please help me with below. I have two different files and I need to join the files but with some condition.
ABC,5000 DEF,6000 GHI,1000
Required output is as below
All columns of file1 + 2nd column of file2 where 1st column of file 1 matches with 1st column of file 2