Re: Saving query result into NEW table
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
>
Alex,
select *
from first_table
where x = ??
into temp temp_table with no log;
Now have at it:
select * from temp_table;
delete from temp_table
where x = ??;etc.
temp tables are very useful.
Hope this helps.
Nick
*********************************
Nick Nobbe, Library of Congress
NLS/BPH
mail: nnob@loc.gov
*********************************