Kbase P117724: Is it possible to create VIEW using tables from several databases?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
GOAL:
Is it possible to create VIEW using tables from several databases?
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
FIX:
No, it is not possible to create VIEW using tables from several databases in SQL-92. This might be possible to do at the client side.
One way to handle this is to create a database where you have the copy of the tables you want from the two other databases.