SELECT ... INTO

MvP14 · Apr 17, 2003

Hi,

can anyone tell me whether I can use the SELECT ... INTO command to enter the results of a temporary query1 into a a to be created table1 and if yes, how?

swampBoogie · Apr 17, 2003

Your question is somewhat unclear, especially at the end.

Code:

SELECT *
   INTO mc
   FROM query1

can be used to create a new table mc with the contents of query1.

To insert data into an existing table named ot, use this

Code:

insert into ot(column_list) select column_list from query1

MvP14 · Apr 17, 2003

Thank you. That helped me out.

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

SELECT ... INTO

MvP14

Technical User

swampBoogie

Programmer

MvP14

Technical User

Similar threads

Part and Inventory Search

Sponsor