Jeanna Geier wrote:
Hello List!
I have a question regarding SELECT INTO...
Can it be used with Views? I have a View that is populated (~35,000 rows)
that I want to create a Table from the data in it....
So, would I be able to copy the data from the View to the Table using the
SELECT INTO command?
SELECT INTO is used in procedural language functions to place column
values into program variables. To copy the contents of a view into a
table, look at instead CREATE TABLE AS or INSERT with SELECT.
--
Guy Rouillier
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
