Re: Saving query result into NEW table
Two possible cases:
1)
NEW is a TEMP TABLE
select F1 from Source where F1<100 INTO TEMP NEW_TABLE [WITH NO LOG];
2)
NEW is a PERMANENT TABLE
INSERT INTO NEW_TABLE select F1 from Source where F1<100
Hope this help!
Byte byte!
Mario R. Canto
mcanto@unl.edu.ar
On Wed, 13 Mar 1996, Alexander Osipov wrote:
> Hi,
>
> 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
>
> Best regards,
> Alexander Osipov