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

Thanks for both answers.

What does M2 stand for ?


What if ID is an autoincrement field ? What should I put instead of 'ID2' ?


Regards,
Primoz