Hi All,
Can some one help me with this logic
Table A
empID EmailId Product
1234 aaa@gmail.com A,B,C
Table B
EmpID EmailID Product
1234 aaa@gmail.com C,D
Join above tables with empid and mailid and update TableA like below
Table A
empID EmailId Product
1234 aaa@gmail.com A,B,C,D
the values in product should be unique.
Solved! Go to Solution.