Is there a way to insert pre-set values and values I get from a select-query?
INSERT INTO table1 VALUES ("A string", 5, [int]).
I have the value of "A string" and the number 5, but I've to find the [int] value from a select like this:
SELECT idTable2 FROM table2 WHERE ...
that gives me that id to put inside table1.
How to merge this into one statement?