Both tables are already populated with data. Currently, this is a 1 to 1 relationship. Each item is only available in 1 color. I need to set it up so that each item is available in multiple colors. I have built tbl3 to allow a 1-to-many relationship going forward:
Here's my question: how can I write a SQL query that handles the existing data, and migrates the current values from the colorId field tbl1 to tbl3, and replaces them in tbl1 with a colorsCollectionId?