SQL copy from one table to another

[jakobt]

Hi,
I have created a table1, with 3 fields: A, B and C, with 500 rows.

I want to copy this data over to table2 starting at row 700.

What is the sql for this.

Additionally I would like to in the 4th column to write November in the same copy over of the 500 rows.

 

[Galaxiom]

The position of records inserted into a table cannot be controlled.

You need to provide more information about your data.

Also why are you doing this?