Re: Normalising an existing table - how?

Graham Leggett wrote:
> Frank Bax wrote:
> 
>> Do all three steps in one command:
>>
>> create table newtable as (select key1, key2, money from oldtable);
> 
> 
> How would I put the primary key of each row in newtable back into 
> oldtable? Also, newtable already exists and contains data - I need to 
> add normalised data to an already partially normalised database.

How can newtable contain data if you don't have any keys for it?

Perhaps a fuller example, with the schemas of the tables in question 
would help.

--   Richard Huxton  Archonet Ltd