insert rows from table into existing table

[joker_r_me]

I have two tables. I want to insert all the columns from table 1 into table
2. then sort table 2 to have a 'pageID' field combine by matching numbers
properly. That will infact make the database made id index mixed up. so how
would I reindex the id field. At the end, how would I remove the fields I
just inserted into table 2 from table 1 and reindex that table all in one
query?

 

[John W. Vinson]

I have two tables. I want to insert all the columns from table 1 into table
2. then sort table 2 to have a 'pageID' field combine by matching numbers
properly. That will infact make the database made id index mixed up. so how
would I reindex the id field. At the end, how would I remove the fields I
just inserted into table 2 from table 1 and reindex that table all in one
query?

STOP.

You're dealing with a fundamental misconception here!

Tables *have no order*. They are Sets, unordered bags of data.

Autonumbers - which I'm guessing you mean by "reindex" - are NOT guaranteed to
be sequential, or gapless.

What is the nature of the data in the two tables? What do you mean by
"matching numbers properly", and what will you do with this (apparently) new
sequential ID number?

 

[Souris]

Thanks millions,

STOP.

You're dealing with a fundamental misconception here!

Tables *have no order*. They are Sets, unordered bags of data.

Autonumbers - which I'm guessing you mean by "reindex" - are NOT guaranteed to
be sequential, or gapless.

What is the nature of the data in the two tables? What do you mean by
"matching numbers properly", and what will you do with this (apparently) new
sequential ID number?