I have one table with this data:
And the other table has this data:
Please note that there are multiple IDs in one cell separated with “;”.
My request is actually quite simple but I can’t figure it out.
- Find match in TABLE1column1 for each ID in TABLE2_column1
- Replace ID in TABLE2 with value of TABLE1_column2
Thank you very much for your help.