The INTO clause behaves the same as CREATE TABLE in other SQL environments ... Simply join two SELECT statements with the UNION keyword to combine the results of two queries into a new table.