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.