Подскажите пример, когда в запросе INSERT применить SELECT. Например:
INSERT INTO TABLE (field_1, field_2) VALUES(V, VALUE_FIELD_FROM_SELECT)
SELECT VALUE_FIELD_FROM_SELECT FROM TABLE2 WHERE ID = 3;
INSERT INTO TABLE (field_1, field_2)
SELECT V, VALUE_FIELD_FROM_SELECT FROM TABLE2 WHERE ID = 3;