Hi ,
I want to join 2 files based on 2 column join condition.
a11
john 2230 5000
a12
XXX 2230 A B 200 345
Expected O/P
John 2230 5000 A B 200
I have tried this
awk 'NR==FNR{a[$2]=$1;next}a[$2]&&sub($1,a[$2])' a11 a12 > a13
john 2230 A B 200 345
Thannksinadvance
Mohan