RE: Select into...

I'm not sure that that is what Jeff is after. insert into table2 select * from table1 assumes that there is a table2 withthe same structure or compatible structure to table1. create table2 as select * from table1 seems to suggest that he wants to create a second table with a structure based on the first. You can create a temporary table in this way by: select * from table1 into temp table2 but this will disappear when theprocess ends. alternatively you can create a view by: create view table2 as select * from table1 which I think is the closestyou'll get to the syntax Mako provided, however this is dynamic 'table' whose contents will change as the contents of table1 change. -----Original Message----- From: William Raper [mailto:WilliamR@catmktg.com] Sent: Thursday, October 14, 1999 1:11 PM To: 'Mako Joe'; informix-list@iiug.org Subject: RE: Select into... The Informix syntax is: insert into table2 select * from table1 -----Original Message----- From: Mako Joe [mailto:eyeofthestorm2@hotmail.com] Sent: Wednesday, October 13, 1999 7:59 PM To: informix-list@iiug.org Subject: Re: Select into... I may be wrong, and I've never tried this on Informix, but I think in Oracle you can do the following: create table2 as select * from table1 Jeff wrote in message ... >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