I have a excell
file with PRODUCT AND ORDER information. It is out of the normal way because the information is all in one table.
I'm uploading% of this information to a database in SQLServer. The first table in the image shows how it is currently. The other two as they should be after normalization. How do I associate the new field created in the products table (ProductCode) with the order? Since in the first denormalized table there is no information for this field?