How to merge the right side data when left side is common using awk

How to merge the right side data when left side is common using awk

References

Reference NO 1

http://stackoverflow.com/questions/15195825/how-to-merge-the-right-side-data-when-left-side-is-common-using-awk

Reference NO 2

http://stackoverflow.com/questions/11524639/merge-two-files-using-awk-and-write-the-output

Reference NO 3

http://www.chemie.fu-berlin.de/chemnet/use/info/gawk/gawk_8.html

Reference NO 4

http://www.math.utah.edu/docs/info/gawk_5.html

Reference NO 5

http://www.ibm.com/developerworks/aix/library/au-unixtext/

Reference NO 6

http://www.grymoire.com/Unix/Awk.html

Reference NO 7

http://oreilly.com/catalog/awkprog3/chapter/ch10.html

Reference NO 8

http://wwwcdf.pd.infn.it/localdoc/awkcard.ps.gz