• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1468
  • Last Modified:

Cross database queries in Firebird 1.5

Is it possible to query multiple databases, joining the data on the specific common fields, and return a result set of the combined data, and if so, how can this be done.
0
mkobrin
Asked:
mkobrin
1 Solution
 
dacaseyCommented:
Yes you use select [column1, column2] from table1, table2 where table1.column1 = table2.column2

Below is a link with some detail for you

http://articles.techrepublic.com.com/5100-10878_11-1050307.html
0
 
mkobrinAuthor Commented:
Thanks dacasey, but what I am looking for is mutiple data bases, not multiple tables. I know how to do this in MSSQL, but am looking for a way to do this in Firbird 1.5
0
 
NickUpsonSenior Network EngineerCommented:
No, firebird 1.5 does not have this ability. It is present in version 2.5 which is just out.

The only way to achieve it is to connect to one database at a time from the client, get the data and handle the join in the client code, horrible I know.
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now