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?
Do all three steps in one command:
create table newtable as (select key1, key2, money from oldtable);
Frank
---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
