cross database select

Thread View: borland.public.interbase.sql

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by dtacheron Fri, 13 Dec 2002 09:09

#11113

Author: dtacheron
Date: Fri, 13 Dec 2002 09:09

6 lines
1014 bytes

Hi,

i have two databases ONE and TWO.
Is it possible with Interbase to execute cross databases queries like this : 
select * from TWO.tableName (i'm connected to database ONE)

Re: cross database select

#11115

Author: Ivan Prenosil
Date: Fri, 13 Dec 2002 09:26

20 lines
1554 bytes

> i have two databases ONE and TWO.
> Is it possible with Interbase to execute cross databases queries like this :
> select * from TWO.tableName (i'm connected to database ONE)

You can
- connect to several databases at the same time, and
- start single transaction against multiple database

But if you look at API, you will find that each command is executed
against single database/single transaction.

It means your example can work
> select * from tableName
but you can't reference both databases in single command like
> select * from ONE.mytable JOIN TWO.tableName ON a=b


--
Ivan
http://www.volny.cz/iprenosil/interbase

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads