Re: Saving query result into NEW table

> 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 Alexander, You could use INSERT INTO tabb SELECT ... However, to do that you would need to create tabb first. If you only want a temporary table you can use a SELECT ..... INTO TEMP tabb Both options have their problems. Malcolm Weallans Online Database Consultancy Phone 01628-72154 Fax 01628-37463 CIX - onlinedbc