Hi,

I have two tables :-


Table 1 :
--------------------------------------

Col 1 Col 2 Col 3

aaa
ccc
jjj



Table 2 :
-------------------------------------------

Col 1 Col 2 Col 3

aaa 1 2
bbb 3 4
ccc 5 6
ddd 7 8
eee 9 10
fff 11 12
ggg 13 14
hhh 15 16
iii 17 18
jjj 19 20

Now, i want to write a code which will search each entry present in Table 1 : Col 1 in Table 2: Col 1 and when a match is found, populate Table 1: Col2 with Table2:Col2 and Table 1:Col3 with Table 2: Col 3



Final output i am looking for would be :-

Table 1

-------------------------------------------

Col 1 Col 2 Col 3

aaa 1 2
ccc 5 6
jjj 19 20