I'm working on an abstraction library in PHP that can do
cross-database/server joins.
So far, I've got inner and left joins going, but you really have to have
both servers on a very fast network, as the amount of data shovelled around
is quite large.

If you're interested, I can open up the development.

N.

> -----Original Message-----
> From: firebird-support@yahoogroups.com
> [mailto:firebird-support@yahoogroups.com] On Behalf Of Adam
> Sent: Wednesday, 23 November 2005 2:59 PM
> To: firebird-support@yahoogroups.com
> Subject: [firebird-support] Re: Queries across FDBs? Across servers?
>
> --- In firebird-support@yahoogroups.com, "eddiehodad"
> <eddie@h...> 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.
>
> No, Firebird does not support cross database queries,
> although it does support cross database transactions with 2
> phase commit. If you implemented the join logic yourself, you
> could get it to work.
>
> >
> > If its not in 1.5.3, I'd be interested to know if anything
> like this
> > is in the roadmap.
>
> I think it is on the maybe one day page.
>
>
>
>
>
> ------------------------ Yahoo! Groups Sponsor
> --------------------~--> Get fast access to your favorite
> Yahoo! Groups. Make Yahoo! your home page
> http://us.click.yahoo.com/dpRU5A/wUILAA/yQLSAA/67folB/TM
> --------------------------------------------------------------
> ------~->
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> 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
>
>
>
>
>
>
>
>
> __________ NOD32 1.1264 (20051024) Information __________
>
> This message was checked by NOD32 antivirus system.
> http://www.eset.com
>
>