A query (SQL statement) that creates a new table and then creates records (rows) in it by copying records from an existing table.