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

[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.


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

[firebird-support] Create a table from Query

[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&t2
 

 Thanks and Regards