This method isn't ANSI-standard SQL, but Microsoft's Transact-SQL extension includes this handy feature. Creating a new table from query results ... to select certain columns from existing tables.