I have two Tables linked by table1s ID. I have selected the rows in this table that I need to change. The selection has a consecutively numbered column. this column has duplicates. They are separated by even and odd numbers.
THe second table is linked by table1s ID. I need to update table 2 so that I can remove the duplicates in table1, consequently the cooresponding rows in table 2. I need to combine the columns in table 2 based on the ID From table 1. Can someone help?