Kbase P55410: Can you do a join of tables in different databases in SQL-92
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
23/01/2004 |
|
Status: Unverified
GOAL:
Can you do a join of tables in different databases in SQL-92?
FACT(s) (Environment):
Progress 9.x
FIX:
No, it is not possible to join tables from different databases using SQL-92. In SQL-92, when a database is connected via ODBC or JDBC, the SQL-92 engine only knows about the tables in that database so consequently attempting to do a join of a table in database #1 to a table in database #2 will fail is the SQL-92 engine that handles the request will know nothing about the other database.