Subject union from 2 database using ODBC: is it possible?
Author Tibor Peák


I'm using the ODBC driver to access Firebird databases.
It is working nice.

I have two databases and I can access them simultaneously with two connection objects.
My question is:

Is it possible to have one  "SELECT .... UNION ... " statement that gets data from both database?

Currently I cannot find the way to do this, maybe it is impossible?

Thanks in advance.