I really should have started with '0, field2' in the example below - assuming field 1 is the primary key.. > If you have an auto incrementing primary key 'id' as the first field > in both tables... > INSERT INTO tableA SELECT 0, field1, field2, field3, etc... FROM tableB >