Re: [firebird-support] Create a table from Query

2018-05-04 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
04.05.2018 14:04, antoedinchar...@gmail.com [firebird-support] wrote: > Is there any way we could create a table in Firebird using the query? No. Firebird cursors (implicit and explicit) are more powerful than MS SQL's ones and let developers avoid local temporary tables completely. --

[firebird-support] Create a table from Query

2018-05-04 Thread antoedinchar...@gmail.com [firebird-support]
Hello, Is there any way we could create a table in Firebird using the query? Ex:- create table temptable as select * from tempquerytable t1, tempquery t2 where t1.slno = t2.slno; this creates a table temptable with the structure of both t1 Thanks and Regards