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.
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.
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
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.