Re: Select into...
Jeff
Assuming that table1 and table2 are identical, try this:
INSERT INTO table1 SELECT * FROM table2;
HTH
Sujit
Jeff <jsouthworth@dsitopdog.com> on 10/13/99 01:45:43 PM
Please respond to Jeff <jsouthworth@dsitopdog.com>
To: informix-list@iiug.org
cc: (bcc: Sujit Pal)
Subject: Select into...
Hi,
I am a MSSQL user trying to find the equivalent to a "Select into". What
this does is create a table from another table without writing to a log
file. Something like this...
Select * into table1 from table2
Is there something like this in Informix?
Thanks in advance,
Jeff