Revolving around the core of technology
We have a need to perform a SQL JOIN on two different databases accessed via different ODBC drivers; I have access to query both ODBC sources of databases; however, I need a method to SQL JOIN on tables in one database (ODBC source1) to another table in another database (ODBC source2)
For example, I have tried selecting ODBC1 from ODBC2 databases: SELECT * FROM AVPM4972127001.tablename. It does not work.