asked
insert with a subquery
how can i do it, avoiding writing too many inserts insert into table A (value1, value2, value3) values(1,-1,(select id from table b where b.column3 = 27 and column4 in (1,2,3,4,5,6))) thanks,
It's a little unclear what you are are trying to do here. If it's a case of just trying to insert those selected id's from table into table then try insert into table (value1, value2, value4) select 1, -1, id from table where column3 = 27 and column4 in (1,2,3,4,5,6)
I am not trying to do a straight insert. I want to insert one record for every value in the in statement in select subquery. if i had to insert traditionally it would be like insert into table A (value1, value2, value3) values(1,-1,(select id from table b where b.column3 = 27 and column4 =1)) insert into table A (value1, value2, value3) values(1,-1,(select id from table b where b.column3 = 27 and column4 = 2)) so on another 4 inserts.
3 People are following this question.
