Re: Saving query result into NEW table
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;
HTH.
--
Cheers,
Billy.
-----------------------------------------------------------------------------
billy.wheeler@pixie.co.za +27 11 803 2151
p.o. box 3463, rivonia, rsa, 2128 +27 83 250 2324
"Have you got it yet?" (c) Kitsch 'n' Sync Productions 1996
-----------------------------------------------------------------------------