I'm transferring many tables (967) from single BDE .DBF files (old
driver DbIV) to Firebird 2.5.

I utilize Delphi 7 as environment and ZEOS components to Firebird
connections: the work is enough easy.

A large number of old queries contain UNIONS and JOINS of tables (->
single files .DBF), but now the old .DBF tables are transferred in
different Firebird Databases. For example, with the two tables
Municipalities.Dbf and ZipCodes.Dbf, I can write with BDE a query
"SELECT * FROM MUNICIPALITIES.DBF a INNER JOIN ZIPCODES.DBF b ON ()...
WHERE..."; now the first table is in WorkCom.fdb database, and the
second table is in the TabCom.fbd database: how to join to day the  tho
tables? My program utilizes this queries and I would want  to find
solutions that give a fast result as BDE.

I know that is not possible for Firebird to join tables that "resides"
in different databases (.fdb), but I must find a solution as elegant as
possible to join the same FB tables previously joined with .DBF files.

Do you have any suggestion as to how to solve this problem?

Thanks in advance.


---
Questa e-mail è stata controllata per individuare virus con Avast antivirus.
https://www.avast.com/antivirus