Inserting multiple rows into a table is simple.

INSERT INTO table1 (id) VALUES (1), (2)

But what if you want to use a subquery to replace the explicit query with something more dynamic. This should be possible, however, searching the internet didn’t get me (or my colleagues) any closer to figuring this out. The obvious attempt of replacing (1), (2) with (subquery) resulted in the error your subquery returns multiple records

In the end we discovered that removing VALUES from the query gave the desired effect.

INSERT INTO table1 (id) (SELECT id FROM table2)

Executing the above query will insert a row into table1 for every result returned by the subquery.