Can we union results from two pass-through queries in Access 2013?

[access_loonie]

Hi folks-

I have two working pass-through queries Q1 and Q2 which are querying two different oracle databases - lets call them DB1 and DB2.

Q1 hits tables in DB1. Q2 hits tables in DB2.


I'm trying to union the two queries in Access 2013, but Access just asks for DB1 credentials (ODBC data source 1), and not DB2. It then errors out saying "ODBC Call Failed. [Oracle][ODBC]Ora-00942: table or view does not exist (#942)
Appreciate any/all help.

Thanks in advance.
-AJ

[alansidman]

Suggest you post the SQL statements for the two queries for analysis and full understanding.