Subject Re: Copy records
Author Svein Erling Tysvær
Hi Martijn! Have you been working too much with other databases lately
or is this yet another thing to blame on the broken part of your body?

--- In, "Martijn Tonies" wrote:
> INSERT INTO master (ID, Name, Town) VALUES
> SELECT 'ID2', Name, Town
> WHERE ID = 'ID1';

Try changing this to

INSERT INTO master (ID, Name, Town)
SELECT 'ID2', M2.Name, M2.Town
FROM master M2
WHERE M2.ID = 'ID1';

(i.e. remove VALUES and add the table once more).

-I didn't think Martijn were having a Bamsemums crisis just yet...