Q:

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?

A:

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...

