multiple database query

Thomas Steinmaurer

Delphi Developer

Mon, 27 Dec 2004 20:23:37 GMT

multiple database query

No.

AFAIK this is only possible if you are using the BDE, which transfers
all data to the client before doing the join.

Regards,
Thomas Steinmaurer
IB LogManager 2.0 - The Logging/Auditing Tool for InterBase and Firebird
http://www.iblogmanager.com

"Willie" <wil...@compliant.co.nz> schrieb im Newsbeitrag
news:3d2d769c$1_2@dnews...

Quote

> Is it possible for an SQL statement to access data from 2 separate
interbase
> databases similar to the way MS-SQL server works e.g.

> select t1.fieldx, t2.fieldy
> from db1.dbo.atable t1
> join db2.dbo.anothertable t2 on t2.field1 = t1.field1

> and if so, could someone please point me at some documentation that
explains
> how to do this.

> thanks
> Willie

Willi

Delphi Developer

Mon, 27 Dec 2004 20:13:01 GMT

Re:multiple database query

Is it possible for an SQL statement to access data from 2 separate interbase
databases similar to the way MS-SQL server works e.g.

select t1.fieldx, t2.fieldy
from db1.dbo.atable t1
join db2.dbo.anothertable t2 on t2.field1 = t1.field1

and if so, could someone please point me at some documentation that explains
how to do this.

thanks
Willie

Other Threads

1. Multiple Database query in Interbase

2. Multiple databases query

3. Querying Multiple databases in one Query

4. Query on multiples databases with Delphi 3

5. Beginner: Queries from multiple databases

6. ADO & query across multiple databases

7. ADO Query & Multiple databases

8. Querying data in multiple VFP databases

9. ADO & Query using multiple databases

10. Query over multiple databases