Hi All,
I wanted to merge two datatable based on name shown below
table 1
id name number
1 x 56
2 y 26
table 2
company name number pnr dv
xxx x 56 s45 q56
yyy d 56 s94 t526
o/p:
table 3:
id name number pnr dv
1 x 56 s45 q56
2 y 26