join files

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

awk 'NR==FNR{a[$2]=$0;next}a[$2]&&sub($1,a[$2])&&sub($(NF - 4), "")' a11 a12

Thanks ,its working fine

Thanks and Regards,
Mohan

If the files are sorted:

join -1 2 -2 2 -o 1.1 1.2 1.3 2.3 2.4 2.5  a11 a12