insert into another table

  • Thread starter Thread starter sheela
  • Start date Start date
S

sheela

I have a table, table1 with fields fild1, field2,..start
position, End Position.
And also another table, table2 with fields field1, field2,
.. Position.
I need to insert data from table 1 to table 2, all the
fields has same information from the table1, except
position field.
The position field value starts from table1.start position
and ends with table1.end position.
It might be easy to understand if I give an example as
follows:
Could some one please help me how to do this?
TIA.
Sheela.

Table1:
Field1 field2 start position end position
A A 1 3
B B 8 9
....

Table2:
Field1 field2 Position
A A 1
A A 2
A A 3
B B 8
B B 9
....
 
Back
Top