Re: Saving query result into NEW table

Billy Wheeler wrote: > > At 08:17 PM 3/13/96 GMT, Alexander Osipov wrote: > >I have one table(Source) and run some query on it. > >With wich SQL I can save query result in NEW table? > > > >F.e. result of: select F1 from Source where F1<100 > > Try: > > SELECT f1 FROM source WHERE f1 < 100 INTO TEMP dest;> > or > > CREATE TABLE dest (f1 CHAR(20)); > INSERT INTO dest SELECT f1 FROM source WHERE f1 < 100; I need to create table giving it's structure from query. Somebody wrote me that it's possible using shemes. Does anybody know how to do it? I need to create PERSISTENT table, not TMP. Alexander