| Subject | Re: [firebird-support] What the best way to to join 2 tables accross 2 databases ? |
|---|---|
| Author | Carlos H. Cantu |
| Post date | 2012-03-19T13:58:03Z |
ABS> Thanks for the clarification... I'm not using 2.5 yet, but I recall to
ABS> take a look on this feature (cross database DML), Perhaps I did an SP to
ABS> check on another database... I will look for the test I did.
What can be done now is a workaround to simulate a cross-db-query,
using a combination of execute statement and Global Temporary Tables.
Not so easy as if cross-db-queries were supported natively, but...
Carlos
Firebird Performance in Detail - http://videos.firebirddevelopersday.com
www.firebirdnews.org - www.FireBase.com.br
ABS> take a look on this feature (cross database DML), Perhaps I did an SP to
ABS> check on another database... I will look for the test I did.
What can be done now is a workaround to simulate a cross-db-query,
using a combination of execute statement and Global Temporary Tables.
Not so easy as if cross-db-queries were supported natively, but...
Carlos
Firebird Performance in Detail - http://videos.firebirddevelopersday.com
www.firebirdnews.org - www.FireBase.com.br