Article:		SQL Subqueries
Subject:		Moving selected information
Date:		2005-10-10 14:04:59
From:		Greg007
I have a database of customers that I need to first, select information from one table in that database and then move it to a new table in that database. I have got as far as selecting the information with SELECT * FROM (table) WHERE (field)="?" Now I just need to know how to move that information into a newly created table.

Showing messages 1 through 1 of 1.

• Moving selected information
  2005-10-16 20:03:54  isabella57 [Reply | View]
  
  
  There are several ways. I think this is the easier. After you selected the information with SELECT, write COPY TO {NEW TABLE NAME} and you will have your select in a new table. After you write OPEN NEW TABLE NAME y you can use it.
  
  ISABELLA57