Hi all,
I have an existing table containing a column in it containing a money
value. I would like to normalise this column into a separate table, as
the money value is to be expanded to contain a tax value, etc.
I have been trying to find a SQL query that will do the following:
- Select the money column from the table
- Populate the new normalised table with each row containing the value
from the original money column
- Write the primary keys of the new rows in the normalised table, back
to a new column in the original table added for this purpose.
This third step I am struggling with - can anyone suggest a query that
might achieve the writing back of the primary key to the original table?
Regards,
Graham
--