Thanks for you replay.

I use below code I got error:

Code:

awk -F"," 'NR==FNR{a[$1];next}{if ($2 in a) print a[$1],$0;else print "Not Found", $0;}'  tmplist srclist

Code:

awk: syntax error near line 1
awk: illegal statement near line 1
awk: illegal statement near line 1

My server is SunOS 5.10 Generic_144488-17 sun4v sparc SUNW,SPARC-Enterprise-

would you please take a look.

Thanks in advance

---------- Post updated at 11:56 AM ---------- Previous update was at 11:52 AM ----------

Thanks for your replay.

when using the code you provide, I got error.
awk: syntax error near line 1
awk: illegal statement near line 1
My server is SunOS 5.10 Generic_144488-17 sun4v sparc SUNW,SPARC-Enterprise-

by the way, would you please briefly explain what "_[$1]", "($2 in _)?" mean?

Thanks in advance