CODEWITHSUNDEEP
sqldb2
Ruslan F.
Ruslan F.

Reputation: 5776

sql insert with subselects

I have SQL Query whitch looks loke this:

INSERT INTO TABEL1 (val1,val2,val3,....,val10,val11)
VALUES (......
(SELECT VAL1 FROM TABELE2 WHERE...),
(SELECT VAL2 FROM TABELE2 WHERE...),
(SELECT VAL3 FROM TABELE2 WHERE...)
.....)

Witch better implementaion of such insert you can suggest?

Upvotes: 0

Views: 183

Answers (1)

user330315
user330315

Reputation: 

INSERT INTO table1 (val1,val2,val3,....,val10,val11)
SELECT val1, val2, val3, ...
FROM table2 
WHERE...

If you want some additional constants then just add them to the select:

INSERT INTO table1 (val1, val2, val3, ...., val10, val11)
SELECT val1, val2, val3, 'some info', 42, ...
FROM table2 
WHERE...

Upvotes: 1

Related Questions