I want to insert a column of other table and one parameter of this table have a hard coded value. I want to iterate this value with the each return value of other table column. How can i do this with insert query?
let 3,4,6 is the return column value of other table.
x
insert into table(value1,value2)
values (2,select id from table2)
Return column
2 3
2 4
2 6
Advertisement
Answer
Get rid of the values
clause:
insert into table(value1,value2)
select 2, id
from table2