Last I heard, Firebird is not slated to permit cross-database joins.

I handle this problem with a small suite of home grown java tools. I
can't give you the suite, but I can give you some ideas. The core of
the suite took me less than three days to write, so you can see it's not
a hard problem.

To java, any DBMS is equally accessible. Set up a configuration file
(or table) that indicates what tables and columns tie together, run your
queries, and let the tool do a nested loop join.

Since my tool is also a data pump and transformer using XML technologies
at its core, generating a report is a matter of applying an XSLT
transformation before pushing output to a file stream.

I hope this helps

On Wed, 2005-11-23 at 03:28 +0000, eddiehodad wrote:
> Hi All,
>
> Not sure how to word the question (ie what you would call such a
> feature), but we have a requirement to develop 2 end user apps based
> on FB, each of which can function independently, but which when both
> installed on the same network, can pool their data for
> cross-application reporting, etc.
>
> To this end, the question has arisen as to whether a query can include
> tables from different FDBs (same server), or even different FDBs on
> different servers.
>
> If its not in 1.5.3, I'd be interested to know if anything like this
> is in the roadmap.
>
> If its not a current OR a planned feature, I'd be interested to hear
> how other users have implemented cross-server reporting.
>
> TIA,
> Andrew
>
>
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>