Re: [firebird-support] Temporary Table In Memory

2016-05-03 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
03.05.2016 14:07, LtColRDSChauhan rdsc1...@gmail.com [firebird-support] wrote:
> 1. I need to run several queries having different fields and conditions on 
> exactly same
> join of tables.
>
> 2. How can i first create such a join of tables in memory and run the queries 
> without
> re-creating the join of tables again and again for each query.

   RTFM doc/sql.extensions/README.global_temporary_tables.txt

-- 
   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] Temporary Table In Memory

2016-05-03 Thread LtColRDSChauhan rdsc1...@gmail.com [firebird-support]
Hi,

1. I need to run several queries having different fields and conditions on
exactly same join of tables.

2. How can i first create such a join of tables in memory and run the
queries without re-creating the join of tables again and again for each
query.

Thanks and regards,
Rajiv