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.
Main Topics Oldest First

Showing messages 1 through 1 of 1.

  • Moving selected information
    2005-10-16 20:03:54  isabella57 [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.