We've expanded our news coverage and improved our search! Visit news.oreilly.com for the latest or search for all things across O'Reilly!
advertisement

Article:
  SQL Subqueries
Subject:   Moving selected information
Date:   2005-10-16 20:03:54
From:   isabella57
Response to: Moving selected information

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