Creating a new table from query results can help you build ... The INTO clause behaves the same as CREATE TABLE in other SQL environments. SELECT * INTO new_table FROM old_table WHERE last_name ...

SQL is neither the fastest nor the most elegant ... or a combination of fields defined by an expression. For example: CREATE TABLE Persons ( PersonID int NOT NULL PRIMARY KEY, PersonName char ...