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

Yes.


--
With regards,
Thomas Steinmaurer
http://www.upscene.com/

Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.