Inserting into different table, specific rows

[jude99]

I need to insert into a different table, but to specify the IDs of the receiving table. Is this possible, please?

Something like ...

insert into table2 (row1, row2,row3)where id IN( 100,1001,1002)

select row1, row2, row3 from table1 where special_number = '9';

 

[r937]

that's too confusing

first of all, it appears that you mean col1,col2,col3 -- not row1,row2,row3

second, the value of ID being equal to 100,1001,1002 would suggest three different rows

perhaps, if you would be so kind, you could show actual sample rows from these tables, to illustrate what you're trying to do

r937.com | rudy.ca