Is it possible to take the results of a SELECT and feed them into a VALUES clause?

[ANTAFRORP]

For Example, is there any way to do something like the following:\[code\]INSERT INTO table2 VALUES(SELECT x FROM table1 WHERE x > 5 LIMIT 4)\[/code\]