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