How To Insert Multiple Rows with a Subquery?

If want to insert rows into a table based on data rows from other tables, you can use a subquery inside the INSERT statement...