I want to create a new table containing only the results from a select statement of another table. How is that done? select a, b, c into destTable from sourceTable where a='x' or a='y' or a='z'; Does one have to create the destTable or is it created for you with the correct structure? Can the rows of one table be used in the select of another table? eg: The above select statement has three choices. could those 'choices' have been rows of a column of a table?
On Wed, 1 Feb 2012 10:29:45 -0800 (PST), SpreadTooThin wrote: > I want to create a new table containing only the results from a select > statement of another table. How is that done? http://dev.mysql.com/doc/refman/5.1/en/create-table-select.html Uhm... You DO know about websearches, right? -- 73. I will not agree to let the heroes go free if they win a rigged contest, even though my advisors assure me it is impossible for them to win. --Peter Anspach's list of things to do as an Evil Overlord