Say I have Table1 with columns X, Y, Z and Table2 with columns X, Y, Z
I want to merge the two tables, but when column X in Table1 and Table2 match to merge their other column values (Y & Z) together separated by a comma (if different).
What is the best way to go about this?
Is there a fancy merge or join I can do, or must I iterate over each and merge them row by row?
1—Happy, Shooter—Gilmore, Mcgavin