The SELECT (with
INTO) statement allows you to select column values from a specified table to insert into variables or to populate a table with data.
See the examples for CREATE (temporary) TABLE for how to use SELECT INTO to populate temporary tables.