This is probably something that won't be highly regarded as a firebird
solution but I have done similar things

for database conversions by using an ODBC driver to talk to the database and
using Access as the front end.



You can link the corresponding tables into Access and then create Access
queries across the linked tables.

If it's a tool only for your own benefit, then it's fine. If you want to
distribute to clients, then it's not really a solution.





Regards
Graeme Edwards





From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of woodpack2020
Sent: Wednesday, 1 March 2006 6:06 AM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Reading data from multiple databases



Is there a way to join data from two database in one query/view?

We have three companies using the same application, each running its
own Firebird database. Is there a way to create one view which reads
data from all the three databases?

I'm not looking for the DataPump tools. I would like to do it in a
Firebird-view.

kind regards, Jan-Henk Reef










++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

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



* Visit your group "firebird-support
<http://groups.yahoo.com/group/firebird-support> " on the web.

* To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com
<mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo!
<http://docs.yahoo.com/info/terms/> Terms of Service.



_____



[Non-text portions of this message have been removed]